Privilege

How to Resolve ORA-01418: specified index does not exist

by Ed Chen
September 30, 2022September 20, 2022

ORA-01418 Tried to alter an index, but it failed with ORA-01418. SQL> alter index emp_emp_id_pk rebuild; alter index emp_emp_id_pk rebuild * ERROR at line 1:… Read More »

How to Resolve ORA-01919: role does not exist

by Ed Chen
August 19, 2022September 26, 2022

ORA-01919 ORA-01919 means that Oracle cannot find any privilege you specified, so it turned to search for the name in roles, but still no luck.… Read More »

IMP_FULL_DATABASE, How and Why

by Ed Chen
August 17, 2022July 26, 2022

IMP_FULL_DATABASE IMP_FULL_DATABASE is one of predefined roles in Oracle database, who provides a bunch of system and object privileges required to perform full database imports… Read More »

Oracle Predefined Role List All

by Ed Chen
August 16, 2022July 26, 2022

Oracle Default Roles What is user role? An user role is a set of related privileges which are required to perform some aspect of tasks,… Read More »

SYS Packages Granted to Public

by Ed Chen
August 12, 2022July 26, 2022

For your reference, here I list packages owned by SYS, which should be granted with EXECUTE privilege to PUBLIC in 19c. DBMS_ADDM DBMS_ADVISOR DBMS_APPLICATION_INFO DBMS_APP_CONT_PRVT… Read More »

How to Resolve PLS-00753: malformed or corrupted wrapped unit

by Ed Chen
August 3, 2022September 7, 2022

PLS-00753 Found a compile error PLS-00753 when we compiled trigger CAT_ROLLBACK_TRIGGER owned by GSMADMIN_INTERNAL. PLS-00753: malformed or corrupted wrapped unit Finally, we found that some… Read More »

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

by Ed Chen
June 21, 2022June 29, 2022

PLS-00201 We have talked about some common patterns of PLS-00201. Here is another case. Found some packages of CTXSYS are invalid, most compile errors are… 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, 2022September 30, 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 25, 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 »