SQL Server Performance Forum – Threads Archive
Understanding stupid application rolessorry. 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!
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.
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.