Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Trigger | Trigger DDL_TRG_ROLE_MGATOOLS | Next Trigger |
CREATE OR REPLACE TRIGGER DDL_TRG_ROLE_MGATOOLS AFTER CREATE OR DROP ON DATABASE DISABLE DECLARE PRAGMA AUTONOMOUS_TRANSACTION; BEGIN if ora_dict_obj_type in ('ROLE', 'ROLE PRIVILEGE') then if ora_dict_obj_name like 'MGATOOLSV2$%' then if ora_sysevent in ('CREATE') THEN insert into role_mgatools(nazwa_roli, opis) values (ora_dict_obj_name, initcap(replace(ora_dict_obj_name,'MGATOOLSV2$','')) ); ELSIF ora_sysevent in ('DROP') THEN delete from role_mgatools where nazwa_roli = ora_dict_obj_name; end if; commit; end if; end if; EXCEPTION when others then null; END; / |
Object Owner | Object Name | Object Type |
---|---|---|
SYS | STANDARD | Package |
SYS | DICTIONARY_OBJ_NAME | Function |
PUBLIC | ORA_SYSEVENT | Synonym |
PUBLIC | ORA_DICT_OBJ_TYPE | Synonym |
PUBLIC | ORA_DICT_OBJ_NAME | Synonym |
F_54 | ROLE_MGATOOLS | Table |
Referencing objects |