Database user privileges

• Mark Bosomworth

  Say Hey Kid

  Points: 669

  More actions

  August 23, 2004 at 9:19 am

  #164717

  Hi,

  Does anyone have a script which lists all the users of each database and their individual permissions, ie data_reader etc and any other specific permission information?

  chuz Mark

• Bill Nye

  Hall of Fame

  Points: 3248

  More actions

  August 23, 2004 at 11:21 am

  #520208

  See:

  http://www.sqlservercentral.com/columnists/cmiller/dumpsqlpermissions.asp

  Also, see sp_helprotect.

  Bill

   

• bellis

  SSCarpal Tunnel

  Points: 4667

  More actions

  August 24, 2004 at 9:07 am

  #520340

  sp_helpuser and sp_helplogins are useful sys sprocs

• Mark Bosomworth

  Say Hey Kid

  Points: 669

  More actions

  August 24, 2004 at 9:32 am

  #520346

  Thanks for all your replies. Some of the SQL and code has given me some useful things to work with.

  chuz Mark