How to make a table read only in Oracle

Oracle 11g allows tables to be marked as read-only using the ALTER TABLE command. ALTER TABLE table_name READ ONLY; ALTER TABLE table_name READ WRITE; Let’s create a table and make it read-only. CREATE TABLE Skant (id NUMBER); INSERT INTO Skant VALUES (1); ALTER TABLE Skant READ ONLY; Any DML statements that affect the table data […]

Read More