Home > Oracle Admin > Make Read Only Table

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
  1. No comments yet.
  1. No trackbacks yet.