Grantee

How to Resolve ORA-39109: Unprivileged users may not operate upon other users' schemas

by Ed Chen
February 1, 2023January 5, 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, 2022March 20, 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
22 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 »