8. SQL Statements : REVOKE : REVOKE Examples
 
Share this page                  
REVOKE Examples
1. Revoke the query_row_limit privilege defined for the role identifier, review_emp, on the employee database.
REVOKE QUERY_ROW_LIMIT ON DATABASE employee
        FROM ROLE review_emp;
2. 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;
3. Prevent user joeb from running the manager bonus database procedure. Fail if joeb has granted execute privilege to other users.
REVOKE EXECUTE ON PROCEDURE mgrbonus
        FROM joeb RESTRICT;
4. 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;
5. Prevent user roger from using role manager.
REVOKE manager FROM roger