REVOKE FROM

How Oracle Revoke All Privileges from User

by Ed Chen
December 2, 2022June 21, 2023

The Principle of Least Privilege At times, you see plenty of unnecessary privileges on user, this is because some privileged user accidentally granted nearly all… Read More »

How to Resolve ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke

by Ed Chen
December 1, 2022March 16, 2023

ORA-01981 Tried to revoke object privileges from an user, but it failed with ORA-01981. SQL> revoke all on HR.EMPLOYEES from OE revoke all on HR.EMPLOYEES… Read More »

Revoke Quota Unlimited on Tablespace from User

by Ed Chen
July 10, 2022April 24, 2023

Revoke Tablespace Quota In previous post, we have talked about how to set quota on tablespace for users. Now, let's see how to revert it.… Read More »

How to Resolve ORA-01927: cannot REVOKE privileges you did not grant

by Ed Chen
June 19, 2022June 23, 2022

ORA-01927 In the previous post, we have talked about error ORA-01952 when revoking an ungranted system privilege from an user. Similarly, we got error ORA-01927… Read More »

How to Resolve ORA-01952: system privileges not granted to

by Ed Chen
June 19, 2022June 6, 2023

ORA-01952 Let's see some error patterns of ORA-01952. CREATE TABLE ALL PRIVILEGES UNLIMITED TABLESAPCE 1. CREATE TABLE Tried to take a privilege away from a… Read More »

JavaScript is not enabled. Please enable it and reload the page.