6 Replies Latest reply on Aug 12, 2005 2:06 PM by Earnest Dyke

    App Roles in SQL Server

    Earnest Dyke Novice

      Greetings all,

      Our DBAs have our SQL Server databases configured so we connect with a user that has not privileges then we must switch to application role using sp_setapprole stored procedure. How can I get this to work with a datasource? I can connect with the user name but getting the sp_setapprole executed is proving more of an issue.

      I have thought about using it in the SQL that is called when a connection is created but the whole reason for using app roles is so no one knows they are being used. Make any sense?

      Any and all help is appreciated.