user permissions on all databases

• geetha@in

  Ten Centuries

  Points: 1235

  More actions

  March 9, 2011 at 9:59 pm

  #233818

  Hi All,

  Could any one give me t-sql script regarding what are the user permissions on all databases in a single instance.

  Thanks To All

  Regars,

  Rekha.

• Henrico Bekker

  One Orange Chip

  Points: 27652

  More actions

  March 9, 2011 at 10:37 pm

  #1296883

  Not going to provide you with a full working script, but only some directions...

  make use of:

  syslogins

  syspermissions

  sys.database_permissions

  sysusers

  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

• @STLSQLGuy

  Default port

  Points: 1476

  More actions

  February 22, 2012 at 8:45 am

  #1450367

  plenty of example scripts on this site you can tweak to meet your needs

  try this one

  http://www.sqlservercentral.com/scripts/permission/76841/

  
  thanks, ERH