|
|
Posted by Simon Hayes on 09/21/05 11:49
I'm not sure what you mean by "see no user information" - securityadmin
is at the server level, so it's used for managing logins.
sp_helplogins, sp_grantlogin etc. are all executable by securityadmin,
so you should be able to view and manage the logins.
At the database level, you need to be in db_accessadmin for the
databases where you need to manage users. sp_helpuser is executable by
public, sp_grantdbaccess is executable by db_accessadmin.
Perhaps you can give some more details of exactly what information you
can't retrieve, and what operations you can't perform?
Simon
Navigation:
[Reply to this message]
|