SQL Server Database Permission Scripts
#1 - Script to get list of all database name and its user in SQL Server USE MASTER GO SELECT SL.dbname AS 'Database Name' ,SL. name AS 'User Name' ,SP.type_desc AS 'Login Type' , SL.denylogin, SL.hasaccess, SL.isntname, SL.isntname, SL.isntgroup, SL.isntuser, SL.sysadmin, SL.securityadmin, SL.serveradmin, SL.setupadmin, SL.processadmin, SL.diskadmin, SL.diskadmin, SL.dbcreator, SL.bulkadmin FROM sys.server_principals AS SP INNER JOIN sys.syslogins AS SL ON SP.SID = SL.SID #2 - Script to get list of all database users and their roles in SQL Server Use Master GO exec sp_msForEachDb ' use [?] select db_name() as [Databast Name ], r.[ name ] as [Role], p.[ name ] as [Member Name ], p.[default_schema_name] as [ Schema ],p.[principal_id] as [Principal Id] from sys.database_role_members m join sys.database_principals r on m.role_principal_id = r.principal_id joi