Триггер SUPERMAG.DBPASSWORDCHANGE : Супермаг Плюс (Супермаг 2000)

SQL> select dbms_lob.substr((SELECT DBMS_METADATA.GET_DDL('TRIGGER','DBPASSWORDCHANGE','SUPERMAG') from dual),4000,1) from dual;

DBMS_LOB.SUBSTR((SELECTDBMS_METADATA.GET_DDL('TRIGGER','DBPASSWORDCHANGE','SUPER
--------------------------------------------------------------------------------

  CREATE OR REPLACE TRIGGER "SUPERMAG"."DBPASSWORDCHANGE"
AFTER ALTER ON DATABASE
BEGIN
	IF ora_dict_obj_type='USER' and
	   ora_dict_obj_name is not null and
	   ora_des_encrypted_password is not null THEN
			SMAddOfficeLog(ora_dict_obj_name,ora_dict_obj_name,'1',5);
	END IF;
END;
ALTER TRIGGER "SUPERMAG"."DBPASSWORDCHANGE" ENABLE