1. Security Model Overview Oracle EBS security is built on a multi-layer authorization model: FND_USER → user identity FND_RESPONSIBILITY → functional access FND_USER_RESP_GROUPS → assignment mapping Unlike database roles, EBS…
Read MorePlease find the below steps to enable the same. create audit policy audit_all actions all only toplevel; audit policy audit_all by user1,user2,user3; audit policy audit_all by sys,system; CONNECT /…
Read MoreThe AUD$ table growth will impact the performance of database so we want to purge it regularly by using the DBMS_AUDIT_MGMT package Check AUD$ table is not in SYSTEM table tablespace.…
Read MoreSteps to move the Audit table from SYSTEM tablespace to newly created tablespace. • Audit trail tables called SYS.aud$ and SYS.fga_log$ keeps all Audit records in the Oracle database and…
Read MoreImpact: Unknown underscore parameters without proper advice from metalink, would impact the database. Solution: We need to ensure that we have proper advises from Oracle Support on those underscore parameters…
Read MorePosted by Narasimha Rao.K Oracle Database and Applications Security Audit Part 1 Introduction: Hello Everyone, I would like to start series of write ups/post based on the experience regarding How to…
Read More