| audit issue [message #521058] |
Fri, 26 August 2011 02:33  |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
Dear all,
I have set the parameter audit_trail to DB,and found the table SYS.AUD$ has record much infomation about login,how can i do not record the info?
login info:
Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1928)) |
|
|
|
|
|
| Re: audit issue [message #521064 is a reply to message #521060] |
Fri, 26 August 2011 03:26  |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
hi,
Other issue: I set the audit_trail to OS,but i can not find any record file in directory D:\ORACLE\ADMIN\ORCL\ADUMP.why?
SQL> show parameters AUDIT;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string D:\ORACLE\ADMIN\ORCL\ADUMP
audit_sys_operations boolean TRUE
audit_trail string OS
SQL> |
|
|
|
|
|
| Re: audit issue [message #521068 is a reply to message #521066] |
Fri, 26 August 2011 03:41 |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
hi,
i have audit select on hxl.tb_hxl_id,and open other session using user hxl to execute select * from tb_hxl_id. the operation can records if the audit_trail set to OS.
Quote:maybe the directory is not accessible to Oracle.
how to check oracle can access the directoty D:\ORACLE\ADMIN\ORCL\ADUMP?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: audit issue [message #521078 is a reply to message #521076] |
Fri, 26 August 2011 04:17 |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
hi,
Quote:Use UTL_FILE and try to create and write a file into this directory.
I don't know how to use UTL_FILE, is there have some examples?
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
