System Privilege

IMP_FULL_DATABASE, How and Why

by Ed Chen
August 17, 2022July 26, 2022

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

How to Resolve ORA-01952: system privileges not granted to

by Ed Chen
June 19, 2022September 30, 2022

ORA-01952 Tried to take a privilege away from a user, but it failed with ORA-01952. SQL> revoke create table from hr; revoke create table from… Read More »

Grant Privilege Correctly

by Ed Chen
June 18, 2022June 25, 2022

Granting vs Revoking Granting a valid privilege to a grantee is easy and can be repeated over and over again, even though the privilege has… Read More »

How to Resolve ORA-00990: missing or invalid privilege

by Ed Chen
June 17, 2022September 30, 2022

ORA-00990 There could be several error patterns of ORA-00990 when we tried to grant some privileges to a user. GRANT CREATE INDEX GRANT CREATE FUNCTION… Read More »

How to Resolve ORA-00942: table or view does not exist

by Ed Chen
March 23, 2019September 21, 2022
4 Comments

ORA-00942 ORA-00942 means that SQL engine found no table or view in your usable scope. In other words, table or view does not exist. The… Read More »

Who has SYSDBA Privilege?

by Ed Chen
October 13, 2012August 5, 2021

SYSDBA Privilege SYSDBA is a system privilege. By default, only SYS has the privilege, but it can be changed by granting to other user. Although… Read More »