Revoke Quota Unlimited on Tablespace from User
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 »Revoke Quota Unlimited on Tablespace from User
REVOKE FROM
How to Resolve ORA-01927: cannot REVOKE privileges you did not grant
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-01927: cannot REVOKE privileges you did not grant
How to Resolve ORA-01952: system privileges not granted to
ORA-01952 Tried to take a privilege away from a user, but it failed with ORA-01952. SQL> revoke create table from hr; revoke create table from… Read More »How to Resolve ORA-01952: system privileges not granted to