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.
Transact-SQL Syntax Conventions
sp_approlepassword [ @rolename= ] 'role' , [ @newpwd = ] 'password'
@rolename = ] ' role '
Is the name of the application role.
Role is , with no default. sysname role must exist in the current database.
@newpwd = ] ' password '
Is the new password for the application role.
password is , with no default. sysname password cannot be NULL.
Do not use a NULL password. Use a strong password. For more information, see
. Strong Passwords
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'
Did you find this helpful?
( 1500 characters remaining)
Thank you for your feedback