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
6. Revoke the idle time limit after which sessions to the employee database will be disconnected:
REVOKE IDLE_TIME_LIMIT ON DATABASE employee FROM PUBLIC;
Note: You must be connected to the iidbdb database to perform this operation.
Last modified date: 08/14/2024