sp_approlepassword
Changes the password of an application role in the current database.
Syntax
sp_approlepassword [ @rolename = ] 'role'
, [ @newpwd = ] 'password'
Arguments
[@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. The new password is encrypted when stored in the Microsoft® SQL Server™ system tables. password cannot be NULL.
Return Code Values
0 (success) or 1 (failure)
Remarks
sp_approlepassword cannot be executed within a user-defined transaction.
Permissions
Only members of the sysadmin fixed server role, and the db_securityadmin and db_owner fixed database roles can execute sp_approlepassword.
Examples
This example sets the password for the PayrollAppRole application role to Valentine.
EXEC sp_approlepassword 'PayrollAppRole', 'Valentine'