Security Wizard Equivalent

[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

 

[Aaron Kempf]

yeah

it's called the system tables

 

[Vayse]

Thanks. That was just the kind of smart answer I was hoping for.

 

[Aaron Kempf]

well what do you need?

Look up sysobject and syscolumns

 

[Sylvain Lafontaine]

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.

 

[Vayse]

Thanks.

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)

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