SQL Language Guide : 8. SQL Statements : REVOKE : REVOKE Examples
 
Share this page                  
REVOKE Examples
The following are REVOKE statement examples:
1. Prevent any user from granting any form of access to the payroll table (assuming no privileges were granted to specific users, groups, or roles). Delete all dependent grants.
REVOKE GRANT OPTION FOR ALL ON payroll
        FROM PUBLIC CASCADE;
2. Prevent user harry from selecting rows from the employees table (assuming the same privilege was not granted to public).
REVOKE SELECT ON employees
        FROM harry CASCADE;
3. Prevent user roger from using role manager.
REVOKE manager FROM roger