
ALT Change table to IMMUTABLE (23.26.2) Convert a table to insert-only Example: create table t ( c1 int ); insert into t values ( 1 ); commit; -- Make table immutable to prevent UPDATE/DELETE alter table t become immutable no drop until 0 days idle no delete until 16 days after insert use ( systimestamp ) for row creation time version v2; update t set c1 = 0; ORA-05715: operation not allowed on the blockchain or immutable tabledelete t; ORA-05715: operation not allowed on the blockchain or immutable table

ALT Read only users & sessions (23.4) Override a user's privileges to stop them making any changes to the database Example: GRANT CREATE SESSION, CREATE TABLE TO query_user IDENTIFIED BY query_user; GRANT SELECT, INSERT, UPDATE, DELETE ON hr.employees TO query_user; ALTER USER query_user READ ONLY; ALTER SESSION SET READ_ONLY = TRUE; ALTER USER query_user READ WRITE; ORA-28194: Can perform read operations only conn query_user/query_user CREATE TABLE t ( c1 INT ); ORA-28194: Can perform read operations only DELETE hr.employees; ORA-28194: Can perform read operations only SELECT COUNT(*) FROM hr.employees; COUNT(*) ---------- 107




























