Export (0) Print
Expand All
Expand Minimize
2 out of 2 rated this helpful - Rate this topic


SQL Server 2000

  New Information - SQL Server 2000 SP3.

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


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


[@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)


sp_approlepassword cannot be executed within a user-defined transaction.


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


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



System Stored Procedures

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft. All rights reserved.