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 SQL Workshop.

2. Click Utilities.

3. Click Object Reports.

   The Object Reports page appears.

4. 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 columns within your 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.

5. To filter a report, enter search criteria in the fields provided or make selections from the lists, and click Go. See Customizing Interactive Reports in the Oracle Application Express Application Builder User's Guide for further details.

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