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
SELECT ANY DICTIONARY
How to Resolve ORA-01952: system privileges not granted to
ORA-01952 Let's see some error patterns of ORA-01952. CREATE TABLE ALL PRIVILEGES UNLIMITED TABLESAPCE 1. CREATE TABLE Tried to take a privilege away from a… Read More »How to Resolve ORA-01952: system privileges not granted to