EBS Customizations (MOSC)

MOSC Banner

Dbms_fga.add_policy audit

edited May 5, 2018 5:03AM in EBS Customizations (MOSC) 2 commentsAnswered

I have enabled audit on the table FND_USER using dbms_fga.add_policy for description and email_address columns using below signature

DBMS_FGA.ADD_POLICY( OBJECT_SCHEMA => 'APPLSYS', OBJECT_NAME => 'FND_USER', POLICY_NAME => 'XX_FND_USER_POL', AUDIT_CONDITION => 'APPS.XX_PRIVACY_LOGGIN_DISABLE=0', AUDIT_COLUMN => 'EMAIL_ADDRESS, DESCRIPTION', ENABLE => TRUE, STATEMENT_TYPES => 'SELECT,INSERT,UPDATE,DELETE');

to my understanding both columns should appear in the table all_audit_policies in audit_column. but for me only email address is showing. however auditing is happening on both. can someone explain this?

i checked the article https://docs.oracle.com/database/121/ARPLS/d_fga.htm#ARPLS66348

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center