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
Privilege
How to Resolve ORA-02224: EXECUTE privilege not allowed for tables
ORA-02224 When we tried to grant some object privilege to an user, it failed with ORA-02224. SQL> grant write on hr.employees to oe; grant write… Read More »How to Resolve ORA-02224: EXECUTE privilege not allowed for tables
How to Resolve ORA-22928: invalid privilege on directories
ORA-22928 Tried to allow an user to be able to access a directory, but it failed with ORA-22928. SQL> grant select on directory data_pump_dir to… Read More »How to Resolve ORA-22928: invalid privilege on directories
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