How to Revoke All Grants from Userby Ed ChenDecember 2, 2022December 3, 2022The 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 Revoke All Grants from User
How to Resolve ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revokeby Ed ChenDecember 1, 2022October 27, 2022ORA-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 »How to Resolve ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke
Revoke Quota Unlimited on Tablespace from Userby Ed ChenJuly 10, 2022October 2, 2022Revoke 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 »Revoke Quota Unlimited on Tablespace from User
How to Resolve ORA-01927: cannot REVOKE privileges you did not grantby Ed ChenJune 19, 2022June 23, 2022ORA-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-01927: cannot REVOKE privileges you did not grant
How to Resolve ORA-01952: system privileges not granted toby Ed ChenJune 19, 2022October 27, 2022ORA-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 »How to Resolve ORA-01952: system privileges not granted to