Re: Question about sys.fga_log$

"DaLoverhino" <DaLoveRhino_at_hotmail.com> a écrit dans le message de news: 1136583354.455741.124650_at_g44g2000cwa.googlegroups.com...
| I'm trying to do fine grain auditing, and using scripts based off the
| rows taken from these tables. Here's two fields I'm particularly
| interested in:
|
| SQLTEXT VARCHAR2(4000)
| LSQLTEXT CLOB
| PLHOL LONG
|
|
| When I do some test runs, I find that the sql select statements are
| found in lsqltext, and plhol. Why are the statements placed the sql in
| more than one field? When will it only be found in one field and not
| the other? And, when will it ever differ if they are placed in more
| than one field?
|
| I am running these scripts on 9.2.0.6, but I will soon have to support
| 10g. Does anyone have the answer, or any insights on the problem?
| Thanks.
|

Why do you want to try to use internal table instead of official and documented view: DBA_FGA_AUDIT_TRAIL?

Regards
Michel Cadot Received on Fri Jan 06 2006 - 16:21:39 CST