Topic
  • 1 reply
  • Latest Post - ‏2019-04-02T13:54:39Z by frisalde
frisalde
frisalde
113 Posts

Pinned topic Running extra SQL commands by Oracle ISIM adapter

‏2019-03-15T08:16:10Z | adapter; commands isim; oracle; sql;

Hi guys,

I would like to add extra SQL commands when an Oracle account is created or modified by ITIM adapter.

 

All the new statements are relative to set the user operations which will be audited. Although, the most interesting feature will be to be able to set based on the user, ie based on provisioning policies, I would be enough to set a fixed number of commands, such as:

 

audit all by ;

 

AUDIT SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE by by access;

AUDIT EXECUTE PROCEDURE BY ;

 

As far as I have been able to see it is not possible. Any idea?

 

BTW, Oracle adapter has not got preexec and postexec capabilities.

  • frisalde
    frisalde
    113 Posts

    Re: Running extra SQL commands by Oracle ISIM adapter

    ‏2019-04-02T13:54:39Z  

    Taking into consideration the Oracle adapter is based on IDI, could the assemble line be modified to execute a SQL procedure where the additional SQL commands are executed, for instance?

     

    Of course, the approach would be out of support, but at least it makes sense. On the other hands  would be to include an manual activity, but due to most of our customer don't consult the result of the operations, I am sure the account would be used before the audit will be enabled, althougt the process would be shown as Pending in ISIM.