TEXT   63

clean_sys sql

Guest on 13th July 2022 08:16:59 AM

  1. --This script is used to clean up the mess due to the fact those objects were created under sys account
  2. --This happened when create_signon_trigger.sql after login as "sys".
  3.  
  4. -- @C:\PingLiu\web\php\sql\clean_sys.sql
  5. conn / as sysdba;
  6. drop table sys.connection_log;
  7. drop sequence sys.connection_log_s1;
  8. drop trigger sys.connection_log_t1;
  9. drop trigger sys.connecting_trigger;

Raw Paste


Login or Register to edit or fork this paste. It's free.