 10g - FGA (Fine Grained Auditing) question [message #147765] |
Sun, 20 November 2005 23:24  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
Has anyone had experience with using FGA(Find Grained Auditing)?
I want to control access to our idxref table, the only place in the database that has ssn's.
I want to audit selects.
Also, if they ask for too many rows, I do not want to return any rows at all. I would have to do a count on the result set of any sql statement that selected the column delta_ssn?
I read the manual but I wondered if anyone could provide any examples?
I do not let anyone update or delete rows via triggers now, but I want a user to be audited if they look at our ssn's.
The idxref table has only two columns, delta_ssn char(9), and delta_id char(9). The delta_id is assigned by the database no matter what a user puts in there on insert.
Thanks!
Neil.
[Updated on: Sun, 20 November 2005 23:25] Report message to a moderator |
|
|
|
|
|
| Re: 10g - FGA (Fine Grained Auditing) question [message #149429 is a reply to message #147765] |
Thu, 01 December 2005 14:31  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
Okay, I read the documentation and the documentation provided by Oracle in the html format.
I am not smart enough to understand how you record selects of a specific column (delta_ssn in my case), or how to set a limit on the number of rows it can give to a user by statemtent and by session.
[Updated on: Thu, 01 December 2005 14:32] Report message to a moderator |
|
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
