Skip to content
This repository has been archived by the owner on Sep 13, 2023. It is now read-only.

Table Reports

Daniel Odievich edited this page Feb 8, 2021 · 15 revisions

Users

List of Users and their details.

Users.CreatedTimeline

Timeline of User creation.

Users.ShowUsers

List of Users that is a direct result of SHOW USERS command.

Roles

List of Roles and their details.

Roles.CreatedTimeline

Timeline of Role creation.

Roles.Hierarchy

Hierarchy of Roles in tabular form.

Roles.ShowRoles

List of Roles that is a direct result of SHOW ROLES command.

RoleMembers

Members of Roles (other Roles and Users).

RoleMembers.CreatedTimeline

Timeline of Role Member assignment/creation.

RolesMembers.ShowGrants

List of Role Members that is a direct result of SHOW GRANTS OF command.

Grants

List of Grants from SHOW GRANTS TO and SHOW GRANTS ON commands.

Grants.Type.Counts

Pivot table of Grants showing Counts by Object Type/Object Name/Privilege/Granted To.

Grants.Type.Privilege

Pivot of Grants showing Counts of Privileges by Object Name/Granted To.

Grants.Role.Privilege

Pivot of Grants showing Counts of Privileges by Granted To/Object Type/Object Name.

Grants.Lst.[ObjectType]

List of Grants for this specific Object Type. Identical to contents of Grants.

Grants.Tbl.[ObjectType]

Table of Grants for this specific Object Type, with Roles in the rows and Privileges in columns.

DB.[DatabaseName]

Single screen view of all permissions in Database, including collapsable groups under each Schema, color-coding of permissions, and popups for long lists of permissions

Clone this wiki locally