Export (0) Print
Expand All
Expand Minimize

sp_approlepassword

SQL Server 2000

  New Information - SQL Server 2000 SP3.

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

Syntax

sp_approlepassword [ @rolename = ] 'role'
    ,
[ @newpwd = ] 'password'

Arguments

[@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. The new password is encrypted when stored in the Microsoft® SQL Server™ system tables. password cannot be NULL.

Security Note  Do not use a NULL password. Use a strong password. For more information, see Security Rules.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_approlepassword cannot be executed within a user-defined transaction.

Permissions

Only members of the sysadmin fixed server role, and the db_securityadmin and db_owner fixed database roles can execute sp_approlepassword.

Examples

This example sets the password for the PayrollAppRole application role to "B3r12-36".

EXEC sp_approlepassword 'PayrollAppRole', 'B3r12-36'

See Also

Application Security and Application Roles

sp_addapprole

sp_setapprole

System Stored Procedures

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft