General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using approles on DBC connections.
I am trying to use SQL Server application roles with the connections used on views created in a database container. Is this possible? Since approles are activated upon a connection, how can I make the DBC(and its views) use a connection handle that I already have the approles activated on, prior to retrieving any data? If I could somehow change the DBC connection handle before it retrieves the data, so I could activate the role on the connection, this would solve my problem. I am aware that I could do all of this by totally using SPT to create and manage my connections and connect strings. I would like to minimize the changes that I would have to make, and we are currently using remote views to retrieve our data.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only