create user user1 password '***' 

create role A1

GRANT A1 TO USER user1 with admin option;

SET TERM ^ ;

CREATE TRIGGER TR_DELRECG_INSRECGCHANGELOG FOR RECG
ACTIVE BEFORE DELETE POSITION 0
AS
begin

  INSERT INTO RecgChangeLog
( 
  ID,
  RECG_K,
  FACTG_K,
  RECGDATE,
  ChangeDate,
  PR_K,
  RG,
  FGL2,
  FACTGN,
  RECN,
  RECGSUM
)

 VALUES

(
 NEXT VALUE FOR GENRECGCHANGELOG,
 old.RECG_K,
 old.FACTG_K,
 old.RECGDATE,
 CURRENT_TIMESTAMP,
 old.PR_K,
 old.RG,
 old.FGL2,
 old.FACTGN,
 old.RECN,
 old.RECGSUM
);

end^

SET TERM ; ^ 

GRANT USAGE ON SEQUENCE GENRECGCHANGELOG TO TRIGGER TR_DELRECG_INSRECGCHANGELOG;