Disable DDL in my Oracle Database

08 Oct, 2012 | techniek | 0 Comments

Ok, so you want to prevent any DDL being executed in your Oracle DB? You could create read-only accounts but here is another way. Create this trigger:

create or replace trigger no_ddl
  before ddl on schema
begin
  raise_application_error( -20001, 'DDL execution temporarily not allowed;');
end no_ddl;

All DDL raises an error, except for the ‘drop trigger no_ddl’ by the way.

0 Comments


Would you like to share your thoughts?

Would you like to share your thoughts?

Leave a Reply

@2019 Plance. All rights reserved.