<< Click to Display Table of Contents >>

Privileges

Top Previous Next

The grid shows all privileges that have been granted on the table, with grantees down the left side and privileges across the top. A capital X shows a privilege that has been granted with the grant option; otherwise a lowercase x is used.

Clicking on the plus sign displays table privileges that have been specified by column. The fact that SCOTT has the UPDATE privilege only on specified columns of the table is shown by the ellipsis, and the popup shows the columns for which it has been granted.

 

frmTables_Privileges

 

The Toolbar and the context menu allow the following operations:

175_Grant

Grant

Shows a modal dialog for granting privileges on the current table to users or roles..

178_Revoke

Revoke

Revokes grants made on the current table. This may be either for all privileges previously granted (by selecting one or more grantees) or for a selected individual privilege (if the row itself is not selected).