Role Privilege

EM_EXPRESS_ALL, How and Why

by Ed Chen
May 17, 2023April 26, 2023

EM_EXPRESS_ALL Whereas EM_EXPRESS_BASIC provides some basic privileges to monitor properties through EM, EM_EXPRESS_ALL, also an Oracle predefined role, has some more advanced privileges which enable… Read More »

EM_EXPRESS_BASIC, How and Why

by Ed Chen
May 16, 2023May 22, 2023

Enterprise Manager (EM) Enterprise Manager (EM) is a graphical management tool that provides centralized capabilities of managing Oracle databases and servers. In recent releases, EM… Read More »

SELECT_CATALOG_ROLE, How and Why

by Ed Chen
May 15, 2023May 16, 2023

SELECT_CATALOG_ROLE Oracle designs several privileges and roles for users who want to query database dictionary views. Two of them are usually used by DBA to… 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 »

Oracle Predefined Roles All Available List

by Ed Chen
August 16, 2022May 23, 2023

Oracle Predefined 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 »

How to Resolve ORA-01031: Insufficient Privileges

by Ed Chen
June 24, 2020May 26, 2023
1 Comment

ORA-01031 ORA-01031: Insufficient Privileges means that the current user did not use the right privilege to process the SQL statement. Since this error can be… Read More »

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