Skip to content

Latest commit

 

History

History
78 lines (55 loc) · 2.36 KB

sp-approlepassword-transact-sql.md

File metadata and controls

78 lines (55 loc) · 2.36 KB
Raw
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sp_approlepassword (Transact-SQL)
sp_approlepassword changes the password of an application role in the current database.
markingmyname
maghan
randolphwest
03/04/2024
sql
system-objects
reference
sp_approlepassword
sp_approlepassword_TSQL
sp_approlepassword
TSQL

sp_approlepassword (Transact-SQL)

[!INCLUDE SQL Server]

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

Important

[!INCLUDE ssNoteDepFutureAvoid] Use ALTER APPLICATION ROLE instead.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: 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