How Oracle Grant All Privileges to User
In Oracle, "all privileges" means all system privileges or all privileges on an object. So we talk about it separately. All System Privileges All Object… Read More »How Oracle Grant All Privileges to User
GRANT
How to Resolve ORA-01917: user or role does not exist
ORA-01917 Tried to grant a privilege to an user, but it failed with ORA-01917. SQL> grant create session to erapp; grant create session to erapp… Read More »How to Resolve ORA-01917: user or role does not exist
How to Resolve ORA-01711: duplicate privilege listed
ORA-01711 Tried to grant some privileges to an user, but it failed with ORA-01711. SQL> grant create session, create session to erpapp; grant create session,… Read More »How to Resolve ORA-01711: duplicate privilege listed
How to Resolve ORA-01700: duplicate username in list
ORA-01700 Tried to grant a privilege to some users, but it failed with ORA-01700. SQL> grant create session to erpapp1, erpapp2, erpapp3, erpapp1; grant create… Read More »How to Resolve ORA-01700: duplicate username in list
How to Resolve ORA-01466: unable to read data - table definition has changed
ORA-01466 Tried to perform a flashback query, but it failed with ORA-01466. SQL> select count(*) cnt from t1 as of timestamp to_timestamp('2023-02-19 22:15:00', 'yyyy-mm-dd hh24:mi:ss');… Read More »How to Resolve ORA-01466: unable to read data - table definition has changed
How Oracle Revoke All Privileges from User
The 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 Oracle Revoke All Privileges from User
How to Resolve ORA-01418: specified index does not exist
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-01418: specified index does not exist
How to Resolve PLS-00753: malformed or corrupted wrapped unit
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-00753: malformed or corrupted wrapped unit
How to Resolve PLS-00201: identifier 'DBMS_SQL' must be declared
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 PLS-00201: identifier 'DBMS_SQL' must be declared
Oracle Grant Privilege Correctly
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 »Oracle Grant Privilege Correctly