System 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 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-01939: only the ADMIN OPTION can be specified

by Ed Chen
April 5, 2023April 4, 2023

ORA-01939 Tried to grant a system privilege to an user, but it failed with ORA-01939. SQL> grant select any table to sh with grant option;… 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 »

Oracle Change User Password

by Ed Chen
November 28, 2022February 21, 2023

Change User Password Periodically, you may like to change your own password for more protection. In fact, there're many ways that can change user's password… 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 »

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