how to get Database user name with respect to Database name

• ham_bit

  Grasshopper

  Points: 11

  More actions

  April 12, 2011 at 10:24 pm

  #249287

  I want to get Database users list with respect to Database Name and Total number of Objects,Tables and Indexes.eg

  User_name Database_name Total_Objects Table_name Indexes Primarykey

• Jack Corbett

  SSC Guru

  Points: 184397

  More actions

  April 13, 2011 at 10:39 am

  #1311180

  You can get the list of database users from sys.database_principals.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question