Edit

Share via

sp_approlepassword (Transact-SQL)

  • Article
  • 03/05/2024

Applies to: SQL Server

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

Important

This feature will be removed in a future version of 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

Syntax

sp_approlepassword
    [ @rolename = ] N'rolename'
    , [ @newpwd = ] N'newpwd'
[ ; ]

Arguments

[ @rolename = ] N'rolename'

The name of the application role. @rolename is sysname, with no default. @rolename must exist in the current database.

[ @newpwd = ] N'newpwd'

The new password for the application role. @newpwd is sysname, with no default. @newpwd can't be NULL.

Important

Don't use a NULL password. Use a strong password. For more information, see Strong Passwords.

Return code values

0 (success) or 1 (failure).

Remarks

sp_approlepassword can't be executed within a user-defined transaction.

Permissions

Requires ALTER ANY APPLICATION ROLE permission on the database.

Examples

The following example sets the password for the PayrollAppRole application role to B3r12-36.

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

Related content