sp_approlepassword (T-SQL)

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 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'

See Also