Viewing Security Reports |
 Previous |
 Next |
Security reports enable you to see privileges granted on database objects owned by other schemas. You can also use these reports to view database roles and system privileges.
Topics:
Viewing Role Privileges
Role Privileges report shows the database roles that have been granted to a selected schema. Roles are collections of various privileges.
To view Role Privileges:
-
On the Database Home Page, click the Utilities icon.
-
Click Object Reports, Security, and then Role Privileges.
The Role Privileges report appears.
Viewing Object Grants
The Object Grants report identifies privileges granted from or to the selected database schema. Use this report to determine the privileges for an existing schema has as well understand what privileges have been granted from the selected schema to other schemas.
To view the Object Grants report:
-
On the Database Home Page, click the Utilities icon.
-
Click Object Reports and then Security.
-
Click User Privileges and then Object Grants.
The Object Grants report appears.
-
From Schema, select the database schema owner.
-
To filter the report, make a selection from the Show list and click Go.
Viewing Column Privileges
The Column Privileges report identifies column privileges granted from or to the selected database schema. Use this report to determine the privileges for an existing schema as well as understand what privileges have been granted from the selected schema to other schemas.
To view the Column Privileges report:
-
On the Database Home Page, click the Utilities icon.
-
Click Object Reports and then Security.
-
Click User Privileges and then Column Privileges.
The Column Privileges report appears.
-
From Schema, select the database schema owner.
-
To filter the report, make a selection from the Show list and click Go.