Script for Trigger DDL_TRG_ROLE_MGATOOLS
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;
/

Trigger DDL_TRG_ROLE_MGATOOLS is referenced by
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

Trigger DDL_TRG_ROLE_MGATOOLS does not have...
Referencing objects