SQL Reports

The following table outlines the SQL reports included in the Report Library. If you are a report user, your administrator may have made some of these reports available in Published Reports.

report name	description
SQL Database Objects	Shows all SQL database objects.
SQL Databases	Shows all SQL databases.
Account Permissions for SQL Database Objects	Shows the direct or indirect database object permissions for the selected accounts.
SQL Database Object Permissions	Shows all SQL database objects and their permissions.
SQL Database Schema Permissions	Shows all database schemas and their assigned permissions on the database.
SQL Database Role Membership	Shows membership for each SQL server role.
SQL Database Role Membership by Account	Shows all database roles of which the selected accounts are direct or indirect members.
SQL Database Users	Shows all SQL database users. If you choose to expand groups, membership of the groups is displayed.
SQL Logins	Shows all SQL logins.
SQL Server Role Membership by Account	Shows all server roles of which the SQL server logins are direct or indirect members.