Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Auditing and Security Manager
"Crow" <ohno_at_youdont.com> wrote in message
news:s1ouht0vassvu0cipng5m6e79tkkemrkma_at_4ax.com...
> I've searched through technet.oracle.com, the USENET groups, and class
> materials and can't find an answer to this.
>
> Why doesn't the audit log show changes made to IDs via Security
> Manager?
>
> I'm running Oracle 8.1.5 on an NT4 SP5 box. I set AUDIT_TRAIL in the
> init file to OS and restarted the instance. I connected via SQLPlus
> and issued the command AUDIT USER. Then, when I open a new SVRMGRL
> session and perform an ALTER USER myid IDENTIFIED BY mypw, it shows up
> in the NT application event log. However, if I go into Security
> Manager (as part of the DBA Management Pack) and change the password
> on the same ID, it doesn't show up in the event log.
>
> Likewise, if I use SVRMGRL to connect as internal, the application log
> shows the connection. When I log into Security Manager using internal,
> the connection doesn't get logged.
>
> Security Manager isn't exempt from auditing, is it? What am I missing?
>
> Thanks in advance!
This might be a bug and you are running a desupported version of Oracle which wasn't exactly flawless. Please get in touch with OTS.
Regards,
Sybrand Bakker, Oracle DBA Received on Thu Jun 07 2001 - 12:25:43 CDT