SQL Server Performance Forum – Threads Archive

Understanding stupid application roles

sorry. Ok, I got my application role created. After discovering there are characters who can and can’t use in the encrypted password got the password encrypted. Why does the app role become active as soon as your password is encrypted? I thought it was only supposed to be activated once the application started running. How do you turn it off so you can do other things. It tells me i "Cannot execute a USE statement while an application role is active." Thanks!

http://www.sqlteam.com/item.asp?ItemID=864
http://www.sqlteam.com/Item.asp?ItemID=753
The user associated with the connection has only those permissions defined by the application role attached to the database to which they’re currently connected.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>