Configuring an Oracle database for PCI, SOX, and HIPAA policies
Regulatory compliance policies capture all types of activities and store the data in FortiDB's repository.
In some cases, this information does not appear in alerts as expected. To avoid this problem, you can execute "create trigger" commands.
- On your Oracle target database, add a file that contains the following script:
- Log into your Oracle instance as sys as sysdba.
- Execute the file.
CREATE OR REPLACE TRIGGER FORTIDB_get_application AFTER LOGON ON DATABASE WHEN (user != 'SYS')
DECLARE l_program VARCHAR2(50);
l_computer VARCHAR2(50);
BEGIN
SELECT substr(program, 1, 43), substr(computer, 1, 20) INTO l_program, l_computer FROM v$session
WHERE audsid = sys_context('USERENV','SESSIONID');
dbms_session.set_identifier(l_program || ':' || l_computer);
EXCEPTION WHEN OTHERS THEN ROLLBACK;
END;
/