Does anyone know how to have a DBC connection connect as an application role or how to grab the connection handle? I have APP= in the connection string, but I need to run sp_setapprole in order to create the view and/or query it because only the app role has select permission. Anyone done this before? Thanks.

Gary