Create Or Replace Drop Trigger Access_Group_Category_Priv_Trg
After Delete Or Insert Or Update
On Scott.Access_Group_Category_Priv 
Referencing New As New Old As Old
For Each Row
Begin 
  If Inserting Then
    Insert Into Sale_Users_Privileges (Privilege_Code, Privilege_Name, Privilege_Priority, User_Id, System_Date)                                          
                                Values(:New.Category_Privilage, :New.Category_Privilage_Desc, :New.Category_Privilage_Priority, 
                                        /*here is a global variable from form*/, Sysdate);
                                                                      
  Elsif Updating Then
   Update Sale_Users_Privileges
      Set Privilege_Code     = :New.Category_Privilage,
          Privilege_Name     = :New.Category_Privilage_Desc, 
          Privilege_Priority = :New.Category_Privilage_Priority,
          User_Id            =  /*here is a global variable from form*/, 
          System_Date        =  Sysdate
    Where Privilege_Code     = :Old.Category_Privilage;
  
  Elsif Deleting Then
   Delete Sale_Users_Privileges
    Where Privilege_Code     = :Old.Category_Privilage;
  End If;
 End;
/

SQL> create table test
  2    (id number,
  3     who varchar2(30)
  4    );

Table created.

SQL> create or replace trigger trg_who
  2    after insert on dept
  3    for each row
  4  begin
  5    insert into test (id, who)
  6      values (seqa.nextval, sys_context('userenv', 'session_user'));
  7  end;
  8  /

Trigger created.

SQL> insert into dept (deptno) values (90);

1 row created.

SQL> select * from test;

        ID WHO
---------- ------------------------------
         7 SCOTT

SQL> grant insert on dept to mike;

Grant succeeded.

SQL> connect mike/lion@ora10
Connected.

SQL> insert into scott.dept (deptno) values (92);

1 row created.

SQL> commit;

Commit complete.

SQL> connect scott/tiger@ora10
Connected.

SQL> select * from test;

        ID WHO
---------- ------------------------------
         8 MIKE
         7 SCOTT

SQL>