You can grant privileges to the following database elements:
Regular and cache tables
Regular and materialized views
Sequences
PL/SQL packages, procedures and functions
To grant privileges on a particular element, right-click the name of the element and select Privileges, then Grant.
In the Users pull-down menu of the Grant dialog box, select the user that you want to grant object privileges to the element. In the Privileges section, put a check in the All check box or click the >> button if you want to grant all available object privileges on the element to the selected user. Otherwise, select the individual privileges from the Available Privileges list that you want to grant to the selected user and then click the > button to move those privileges into the Selected Privileges list. To select more than one privilege, press and hold the CTRL key, and click the desired privileges. Click the Apply button to grant the selected object privileges on the element to the selected user.
For a particular element type, only the available object privileges are shown.
Only users with the ADMIN system privilege or the owner of the particular element can grant object privileges on that element.
Related Topics