How to summarize the security settings for an account.??????

• ¥♥ürz.§µññÿ

  Mr or Mrs. 500

  Points: 563

  More actions

  February 19, 2013 at 8:35 am

  #289492

  Hi

  I have 2 sql Login accounts and for these 2 accounts

  How to find out the

  1. Server Roles (bulkadmin, dbcreator,diskadmin etc.,).????

  2. user mapped databases.????

  3. database roles.????

  4. database role and user database is 1-to-1 mapping or not.????

  Ex: TestDB ---> mapped to ---> db_datareader

  SampleDB ---> mapped to ---> db_ddladmin

  5. Deny access on Tables.????

  Please advice me any script or any solution.

  🙂 Thanks

• Ant-Green

  SSC Guru

  Points: 113445

  More actions

  February 19, 2013 at 8:40 am

  #1589237

  Select from sys.server_permission for server wide permissions (grant deny roles etc) joined to sys.server_principles

  Select from sys.database_permissions in each database for DB wide permissions joined to sys.database_principles