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
Object Privilege
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-01749: you may not GRANT/REVOKE privileges to/from yourself
ORA-01749 Tried to grant some object privilege to the user, but it failed with ORA-01749. SQL> show user USER is "HR" SQL> grant select on… Read More »How to Resolve ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
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-00993: missing GRANT keyword
ORA-00993 Tried to grant an object privilege to an user, but it failed with ORA-00993. SQL> grant select on hr.employees to sh with admin option;… Read More »How to Resolve ORA-00993: missing GRANT keyword
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