Security Wizard Equivalent

  • Thread starter Thread starter Vayse
  • Start date Start date
V

Vayse

Hi
When I was using mdb, I would use the security wizard to print off the users
and groups.
Is there any wizard for printing the SQL Users and Roles?
Thanks
Vayse
 
There is no such wizard but you could use things like sp_helplogins and
sp_helpuser to find about them:

http://msdn2.microsoft.com/en-us/library/ms190304.aspx
http://msdn2.microsoft.com/en-us/library/ms187732.aspx

In the case of sp_helplogins, LoginName with AUSER = 'yes' are the most
interesting to you because they are those which are associated with at least
one database and are displayed in the second report (or resultset).

For more info:
http://vyaskn.tripod.com/sql_server_security_best_practices.htm
http://vyaskn.tripod.com/troubleshooting_orphan_users.htm
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q246133

Etc...

A better place to ask this question would be in the m.p.sqlserver.security
newsgroup.
 
Thanks.
Sylvain Lafontaine said:
There is no such wizard but you could use things like sp_helplogins and
sp_helpuser to find about them:

http://msdn2.microsoft.com/en-us/library/ms190304.aspx
http://msdn2.microsoft.com/en-us/library/ms187732.aspx

In the case of sp_helplogins, LoginName with AUSER = 'yes' are the most
interesting to you because they are those which are associated with at
least one database and are displayed in the second report (or resultset).

For more info:
http://vyaskn.tripod.com/sql_server_security_best_practices.htm
http://vyaskn.tripod.com/troubleshooting_orphan_users.htm
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q246133

Etc...

A better place to ask this question would be in the m.p.sqlserver.security
newsgroup.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


Vayse said:
Hi
When I was using mdb, I would use the security wizard to print off the
users and groups.
Is there any wizard for printing the SQL Users and Roles?
Thanks
Vayse
Click to expand...
Click to expand...
 
Back
Top