Hi guys,
Is there anyway to allow SQL Server users to change their own passwords without giving them rights to "db_securityadmin" ?
Our M$ adviser suggested creating our own app using SQL NS and DMO to do it.
Is there any easier method, reference, download sample from the web?from qa:
sp_password 'oldpassword', 'newpassword'|||Without giving them sysadmin or securityadmin , is it possible?
I mean ..just changing their own password...
I wrote this:
EXEC sp_password '123', '456', 'test1'
I got this error:
"Only members of the sysadmin role can use the loginame option. The password was not changed."
But I read this in Books Online, can't really understand it yet...:
Permissions
Execute permissions default to the public role for a user changing the password for his or her own login. Members of the securityadmin and sysadmin fixed server roles can change the password for another user's login.|||woppps...of course...just exclude the loginname...sorry bout that...
okay ..thanks..it works!
EXEC sp_password '123', '456'
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment