OraFAQ Forum: Security » Exempt users from FGA policy

Home » RDBMS Server » Security » Exempt users from FGA policy

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Exempt users from FGA policy [message #64442]

Sat, 29 January 2005 10:47

Daniel
Messages: 47
Registered: February 2000

Member

Hi,
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.

Daniel

Report message to a moderator

Re: Exempt users from FGA policy [message #109610 is a reply to message #64442]

Sun, 27 February 2005 04:05

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Grant EXEMPT ACCESS POLICY to those users.

Best regards.

Frank

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 11:13:30 CDT 2025