System Privilege

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

by Ed Chen
June 19, 2022June 23, 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 23, 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, 2022June 23, 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, 2019October 12, 2021
4 Comments

ORA-00942 ORA-00942 means that SQL parser saw no such table or view in your usable scope while parsing SQL statement. In other words, table or… 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 »