Home » RDBMS Server » Security » Exempt users from FGA policy
Exempt users from FGA policy [message #64442] Sat, 29 January 2005 10:47 Go to next message
Messages: 47
Registered: February 2000
I have added a FGA policy that audits all queries made to a particular table that contains sensitive data. By default, the policy is enabled and applies to all users of the database. Is there a way I can exempt a user from the policy; not generate a log within the fga audit trail when queried by an exempt user. I would hate to have to create a process to run every hour or so to delete records from the fga audit trail to remove that particular user.

Any help is appriciated.

Re: Exempt users from FGA policy [message #109610 is a reply to message #64442] Sun, 27 February 2005 04:05 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Grant EXEMPT ACCESS POLICY to those users.

Best regards.

Previous Topic: Prevent Access Users From Having Read/Write Access
Next Topic: About connection with sysdba
Goto Forum:

Current Time: Tue May 21 12:38:17 CDT 2024