ORA-00990

Grant Quota Unlimited on Tablespace to User

by Ed Chen
July 10, 2022December 30, 2022

Grant Tablespace Quota Since quota usage limitation is not an object privilege, we can't grant it like this: SQL> grant quota 100g on erpapp_tbs_01 to… Read More »

Oracle Grant Privilege Correctly

by Ed Chen
June 18, 2022March 20, 2023

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 »