sp_approlepassword

Transact-SQL Reference

Transact-SQL Reference

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'

See Also

Application Security and Application Roles

sp_addapprole

sp_setapprole

System Stored Procedures