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.