sp_approlepassword (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Changes the password of an application role in the current database.


This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use ALTER APPLICATION ROLE instead.

|Applies to: SQL Server ( SQL Server 2008 through current version).|

Topic link icon Transact-SQL Syntax Conventions


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.


Do not use a NULL password. Use a strong password. For more information, see Strong Passwords.

Return Code Values

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 B3r12-36.

EXEC sp_approlepassword 'PayrollAppRole', '''B3r12-36';  

See Also

Security Stored Procedures (Transact-SQL)
Application Roles
sp_addapprole (Transact-SQL)
sp_setapprole (Transact-SQL)
System Stored Procedures (Transact-SQL)