DBA_ROLE_PRIVS

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

by Ed Chen
February 1, 2023May 23, 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 »

How Oracle Revoke All Privileges from User

by Ed Chen
December 2, 2022May 23, 2023

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 »

DATAPUMP_IMP_FULL_DATABASE, How and Why

by Ed Chen
November 22, 2022April 26, 2023

DATAPUMP_IMP_FULL_DATABASE DATAPUMP_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 »

DATAPUMP_EXP_FULL_DATABASE, How and Why

by Ed Chen
November 21, 2022April 26, 2023

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

EXP_FULL_DATABASE, How and Why

by Ed Chen
August 17, 2022May 23, 2023

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

IMP_FULL_DATABASE, How and Why

by Ed Chen
August 17, 2022May 23, 2023

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 »

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