Changes the password of an application role in the current database.
|Applies to: SQL Server (SQL Server 2008 through current version).|
sp_approlepassword [ @rolename= ] 'role' , [ @newpwd = ] 'password'
[ @rolename = ] 'role'
Is the name of the application role. Role is sysname, with no default. role must exist in the current database.
[ @newpwd = ] 'password'
Is the new password for the application role. password is sysname, with no default. password cannot be NULL.
0 (success) or 1 (failure)
sp_approlepassword cannot be executed within a user-defined transaction.
Requires ALTER ANY APPLICATION ROLE permission on the database.
The following example sets the password for the
PayrollAppRole application role to
EXEC sp_approlepassword 'PayrollAppRole', '''B3r12-36';