Use the Revoke tab to revoke connect through privileges and roles through the trusted user.
- In the Navigator view, double-click Databases.
- In the Object List Viewer, right-click the user and select Modify Connect Through Privileges.
- Click Revoke.
-
Modify options:
Option Action Trusted Users Select the trusted user who is revoking previously granted connect through privileges and roles from the associated users. Revoke Select the check boxes from the Privileges to be Revoked list. A user can have up to 15 rows depending on the associated roles. When checked, that connect through privilege or role is revoked when committed. Revoke All [Optional] Select this check box to select all connect through privileges and roles in the Privileges to be Revoked list. - Click the SQL category to verify the generated SQL is correct.
- Click Commit.