To Grant or Remove Object Privileges:

  1. Open the User node on the object tree. The Users page will open.

  2. Double click the user name in the tree or on the users table. The Properties page will open.

  3. Select the Permission tab at the top of the page. The Permission page will appear.

    Note: Users with DBA privilege have permission on all objects in the database.

  4. Click Modify to alter the user's object privilege. Choose which type of privilege to grant to the user on each object. Click the column and row corresponding to the object privilege to be granted and the object to grant the privilege to. Privileges can be likewise removed. A check mark will appear for each privilege selected as in the table below.

  5. Click Confirm to save the changes, or Cancel to discard them.


Related topic:

Granting and Removing Object Privileges