Security Reports

Use the Security reports to view object or column privileges granted on database objects owned by other schemas. You can also use these reports to view database role and system privileges.

To view the Security reports:

1. On the Workspace home page, click the Utilities icon.

2. Click Object Reports.

   The Object Reports page appears.

3. In the Security Reports section, click the report you want to view:

   • Object Grants - View the privileges for an existing schema and also understand what privileges have been granted from the selected schema to other schemas.

   • Column Privileges - View the privileges for an existing schema and also understand what privileges have been granted from the selected schema to other schemas.

   • Role Privileges - View the database roles that have been granted to a selected schema. Roles are collections of various privileges.

   • System Privileges - View the database privileges that have been granted to a selected schema.

4. If available, you can filter the report by making a selection from the Show list and clicking Go.

5. To view reports for a different schema, select the schema from the Schema list on the upper right side of the page.