Users access to Databases

• Sathish Kumar. Rajaram

  Mr or Mrs. 500

  Points: 581

  More actions

  July 1, 2005 at 6:57 am

  #89869

  Hi

  I have many users having access to many databases. Now I need a list which lists users who have access to the databases.

  I tried, but the result shows the user id with its associated default database name. But I need all the database associated with that user

  Eg.

  UserName         DBName

  User1              DB1

  User1              DB2

  User1              DB4

  User2              DB2

  User2              DB3

  User3              DB2

  User3              DB3

  User4              DB4

  Thanks in Advance

  Sathish Kumar. R

  S A T ...
  Sathish's Blog

• ChrisMoix-87856

  SSCertifiable

  Points: 7288

  More actions

  July 1, 2005 at 7:12 am

  #570298

  There's a pretty good script for this in the script section. Do a search for 'Script to list all user and roles'

  It will list users, roles, and database access (not the type of access, but what users and roles are permitted to which databases).

• Sathish Kumar. Rajaram

  Mr or Mrs. 500

  Points: 581

  More actions

  July 3, 2005 at 10:42 pm

  #570572

  Hi Chris Moix,

  Thanks a lot. I got the script.

  Sathish ...

  S A T ...
  Sathish's Blog