APP Role

[accessman2]

Hi,

I create the application role. But, I want to update the new password on each month. So, do we have statement to update/modify the password on the application role?

And, can we copy application role and paste it with the new name?

 

[SQL_Hell]

there is no fuction to change passwords, drop the login and recreate it with a different password

 

[SQL_Hell]

sorry my mistake....

you can use sp_approlepassword to change the application role password

 

[SQL_Hell]

I was thinking about this last night and to be honest I would stear clear from application roles and use windows groups, much easier to administer and there wont be the problem of select user() returning the application role name rather than the actual username. Using windows groups is also the Microsoft prefered method.

The only other option should you continue to use Application roles is to parse the user name to the database from the application.