Privilege

How to Resolve PLS-00201: identifier 'DBMS_SQL' must be declared

by Ed Chen
June 21, 2022June 22, 2022

PLS-00201 Found some packages of CTXSYS are invalid, most compile errors are in the same pattern, PLS-00201. PLS-00201: identifier 'DBMS_SQL' must be declared PLS-00201: identifier… 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 23, 2022

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 »

Grant Privilege Correctly

by Ed Chen
June 18, 2022June 23, 2022

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 »

How to Resolve ORA-00990: missing or invalid privilege

by Ed Chen
June 17, 2022June 23, 2022

ORA-00990 There could be several error patterns of ORA-00990 when we tried to grant some privileges to a user. GRANT CREATE INDEX GRANT CREATE FUNCTION… Read More »

How to Resolve ORA-02030: can only select from fixed tables/views

by Ed Chen
March 30, 2022April 9, 2022

ORA-02030 Tried to grant SELECT object privilege to an user, but it failed with ORA-02030. SQL> grant select on v$session to erpapp; grant select on… Read More »

How to Resolve ORA-17628 Error Message

by Ed Chen
November 16, 2020May 5, 2022
2 Comments

ORA-17628: Oracle error 1031 returned by remote Oracle server In some situations, you might see errors like the following when cloning a remote pluggable database… Read More »

How to Resolve ORA-01031: Insufficient Privileges

by Ed Chen
June 24, 2020June 18, 2022
1 Comment

ORA-01031 ORA-01031: Insufficient Privileges means that the current user did not use the right privilege to process the SQL statement. Since this error can be… Read More »

How to Resolve ORA-04063: view has errors

by Ed Chen
December 7, 2019April 27, 2022

ORA-04063 ORA-04063 means the view that you want to grant to someone else has compile error, so the database cannot grant it to other users.… Read More »

How to Resolve ORA-01720: grant option does not exist

by Ed Chen
December 3, 2019February 7, 2022
14 Comments

ORA-01720 Got error ORA-01720 when we tried to grant an object privilege to another user. ORA-01720 means that the grantor doesn't have the right privilege… Read More »