How Oracle Grant All Privileges to User
In Oracle, "all privileges" means all system privileges or all privileges on an object. So we talk about it separately. All System Privileges All Object… Read More »How Oracle Grant All Privileges to User
System Privilege
DBA Role, How and Why
DBA Role In Oracle database, DBA could be the most privileged role. Whenever we want to make a user to be the most dominant application… Read More »DBA Role, How and Why
EM_EXPRESS_ALL, How and Why
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_ALL, How and Why
EM_EXPRESS_BASIC, How and Why
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 »EM_EXPRESS_BASIC, How and Why
SELECT_CATALOG_ROLE, How and Why
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 »SELECT_CATALOG_ROLE, How and Why
How to Resolve ORA-01917: user or role does not exist
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-01917: user or role does not exist
How to Resolve ORA-01711: duplicate privilege listed
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-01711: duplicate privilege listed
How to Resolve ORA-01700: duplicate username in list
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-01700: duplicate username in list
How to Resolve ORA-01939: only the ADMIN OPTION can be specified
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 to Resolve ORA-01939: only the ADMIN OPTION can be specified
How Oracle Revoke All Privileges from User
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 »How Oracle Revoke All Privileges from User