Grant Object Privileges to a TimesTen Database Element

You can grant privileges to the following database elements:

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

TimesTen Tasks

SQL Developer Concepts and Usage