ORA-01952

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, 2022October 27, 2022

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 »

Oracle Grant Privilege Correctly

by Ed Chen
June 18, 2022May 23, 2023

Granting vs Revoking Granting a valid privilege to a grantee is easy and can be repeated over and over again, even though the privilege has… Read More »

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