This blog is a note for self learning. Some writings are done by myself and some are collected, just to keep things in a organized way.
7.01.2012
Prevent DDL Trigger:
DROP TRIGGER prevent_ddl_t;
CREATE OR REPLACE TRIGGER prevent_ddl_t
BEFORE ALTER OR DROP OR TRUNCATE
ON SCHEMA
BEGIN
RAISE_APPLICATION_ERROR(-20001,' You are not authorized to perform DDL.');
END;
/
