Changing Password

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Emma - 27 Sep 2005 14:52 GMT

How can I assign a user the ability to change/reset password for users
assigned to one particular database only in EM. Example, Northwind is one of
the databases in my system; I want the user john to be responsible for
changing/resetting password for users with access to Northwind database only
and nothing else. Is this possible? If so, how do I do it?

Thanks
Emma

Reply to this Message

Sue Hoegemeier - 27 Sep 2005 23:21 GMT

Passwords are assigned to logins which are at the server
level. And only sysadmins and securityadmins can execute
sp_password. But that's at a server level, not the database
level. So no, not if you want to restrict it to just one
database.

-Sue

>How can I assign a user the ability to change/reset password for users
>assigned to one particular database only in EM. Example, Northwind is one of
[quoted text clipped - 4 lines]
>Thanks
>Emma

Reply to this Message