REVOKE

How to Resolve ORA-01466: unable to read data - table definition has changed

by Ed Chen
March 16, 2023March 21, 2023

ORA-01466 Tried to perform a flashback query, but it failed with ORA-01466. SQL> select count(*) cnt from t1 as of timestamp to_timestamp('2023-02-19 22:15:00', 'yyyy-mm-dd hh24:mi:ss');… Read More »

How to Revoke All Privileges from User

by Ed Chen
December 2, 2022March 12, 2023

The Principle of Least Privilege At times, you see plenty of unnecessary privileges on user, this is because some privileged user accidentally granted nearly all… Read More »

How to Resolve ORA-01927: cannot REVOKE privileges you did not grant

by Ed Chen
June 19, 2022June 23, 2022

ORA-01927 In the previous post, we have talked about error ORA-01952 when revoking an ungranted system privilege from an user. Similarly, we got error ORA-01927… Read More »

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

by Ed Chen
June 19, 2022October 27, 2022

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 »

LAST_DDL_TIME, How and Why

by Ed Chen
March 11, 2022March 21, 2023

LAST_DDL_TIME Generally speaking, LAST_DDL_TIME in ALL_OBJECTS or DBA_OBJECTS means that the last time of the object definition changed by Data Definition Language (DDL). But sometimes,… Read More »