To revoke privileges from a particular element, right-click the name of the element and select Privileges, then Revoke.
In the Users pull-down menu of the Revoke dialog box, select the user that you want to revoke object privileges from the element. In the Privileges section, put a check in the All check box or click the >> button if you want to revoke all granted object privileges on the element from the selected user. Otherwise, select the individual privileges from the Available Privileges list that you want to revoke from 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 revoke the selected object privileges on the element from the selected user.
The Users pull-down menu only shows users who have been granted object privileges on the element. For a particular user, only the object privileges that they have been granted are shown.
Only users with the ADMIN system privilege or the owner of the particular element can revoke object privileges from that element.
Related Topics