Make Read Only Table
This script is used for protect table from modification (read only) :
CREATE TRIGGER tab_readonly
BEFORE DELETE OR INSERT OR UPDATE
ON emp
FOR EACH ROW
BEGIN
RAISE_APPLICATION_ERROR(-20201, ‘Table Status: READ ONLY.’);
END;
Categories: Oracle Admin
Recent Comments