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.|
- [ @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.
Security Note: Do not use a NULL password. Use a strong password. For more information, see Strong Passwords.
The following example sets the password for the
PayrollAppRole application role to
EXEC sp_approlepassword 'PayrollAppRole', '''B3r12-36'