Home > SQL Developer: TimesTen Tasks > Grant Object Privileges to ...
You can grant privileges to and revoke privileges from the following database objects:
Regular and cache tables
Regular and materialized views
Sequences
PL/SQL packages, procedures and functions
To grant privileges on an object, right-click the name of the object and select Privileges, then select Grant.
In the Users drop-down menu of the Grant dialog box, select the user to grant object privileges to the object. In the Privileges section, select the All check box or click >> to grant all available object privileges on the object to the selected user. Otherwise, select the individual privileges from the Available Privileges list for the privileges to grant to the selected user and then click > to move those privileges into the Selected Privileges list. To select multiple privileges, press and hold the CTRL key, and click the desired privileges. Click Apply to grant the selected object privileges on the object to the selected user.
For a particular object type, only the available object privileges are shown. For example, DELETE, INDEX, INSERT, REFERENCES, SELECT and UPDATE privileges can be granted on a table. However, only INDEX, REFERENCES and SELECT privileges can be granted on a materialized view.
Only users with the ADMIN system privilege or the owner of an object can grant object privileges on the object.
For more information about the set of privileges available to each type of object, see "Object privileges" in the Oracle TimesTen In-Memory Database SQL Reference.
Related Topics