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
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
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