Grantee

How to Resolve ORA-01749: you may not GRANT/REVOKE privileges to/from yourself

by Ed Chen
May 12, 2023April 13, 2023

ORA-01749 Tried to grant some object privilege to the user, but it failed with ORA-01749. SQL> show user USER is "HR" SQL> grant select on… Read More »

How to Resolve ORA-01917: user or role does not exist

by Ed Chen
April 10, 2023April 11, 2023

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-01711: duplicate privilege listed

by Ed Chen
April 7, 2023March 3, 2023

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-01700: duplicate username in list

by Ed Chen
April 6, 2023April 6, 2023

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-39109: Unprivileged users may not operate upon other users' schemas

by Ed Chen
February 1, 2023June 8, 2023

ORA-39109 Saw error ORA-39109 when we tried to export someone's data from the database. C:\Users\Administrator>expdp ERPAPP@APPDB1 schemas=FINAPP dumpfile=FINAPP-export.dmp logfile=FINAPP-export.log ... ORA-31631: privileges are required ORA-39109:… Read More »

How Oracle Check User Default Role

by Ed Chen
January 31, 2023March 20, 2023

User Default Role Making roles default to a user has some advantages, it automatically enables all privileges in the default roles when the user logs… Read More »

Oracle Grant Privilege Correctly

by Ed Chen
June 18, 2022June 21, 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 »

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

by Ed Chen
December 3, 2019March 3, 2023
26 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 »

How to Grant All Tables Owned by Others

by Ed Chen
October 13, 2012March 17, 2023

Grant All Tables at Object Level For those who don't like the old username and want to switch all data to a well-named user, you… Read More »

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