Logins and permissions- reporting

• mise13

  SSC Enthusiast

  Points: 128

  More actions

  August 6, 2003 at 7:52 am

  #160612

  I am trying to set up security in our test environment- up till now, everyone most people just used SA.

  I would like to generate some reports so I can review what we have now, and what I set up.

  Report 1:

  In particular, I would like to see

  For each Database, who has access

  Example:

  DB Capital

  User01 R,W

  User02 R

  User03 R,W

  DB Company

  User02 R

  User04 R,W

  Report 2:

  For each login, what db access do they have

  ExampleL

  User01

  Capital R,W

  User02

  Capital R

  Company R

  Where R= Read

  W = Wrote

• brokenrulz

  SSCrazy

  Points: 2261

  More actions

  August 8, 2003 at 3:42 am

  #469146

  You can take hlp of the extended stored procedure sp_table_privileges.

  May be this will you.

  Relationships are like Banks.You Invest the Principal and then get the Interest.

  
  He who knows others is learned but the wise one is one who knows himself.