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

[Back to original message]