| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: USERENV('SESSION_ID') / auditing
the documentation is wrong in this case. I opened a doc bug yesterday after
seeing this, bug #765506. Hopefully ,it will get updated in the next release of
the documentation...
A copy of this was sent to "Mark Powell" <Mark.Powell_at_eds.com> (if that email address didn't require changing) On 18 Nov 1998 14:41:56 GMT, you wrote:
>The audit_trail = TRUE was from version 7.0. I do not remember if the
>options changed with 7.2 or 7.3
>
>We have the audit_trail set to none and the function still works on 7.3.3.5
>under Dcosx Unix. I believe that the SQL manual is wrong and has been for
>some time.
>
>
>Vic Thomas <vic04_at_sprynet.com> wrote in article
><72s9uv$hh9$1_at_juliana.sprynet.com>...
>> The documentation for versions 7.3 and 8.0 both state that to be able
>to
>> use the 'SESSION_ID' keyword in the USERENV() function, the
>initialization
>> parameter AUDIT_TRAIL must be set to TRUE.
>> This documentation is a bit misleading for a number of reasons.
>First,
>> the INIT.ORA parameter setting AUDIT_TRAIL can only be set to
>[NONE|DB|OS].
>> "TRUE" is not an option. Second, even if I start up the instance with
>> AUDIT_TRAIL set to "NONE", the USERENV('SESSION_ID') still returns a
>valid
>> value!
>> So what's going on here? Is the Oracle documentation just completely
>> and wildly inaccurate? Is that possible? ;^)
>> Incidentally, I've noticed this behavior both in Oracle 7.3.2.3.1 on
>> Windows NT Server and in Oracle 7.3.4.2.0 on HP-UX. Could this behavior
>be
>> platform-specific?
>>
>> ----
>> Vic Thomas
>> Database Analyst
>> Associated Software Consultants
>> vic04_at_sprynet.com; vic_at_asconline.com
>>
>>
>>
>>
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Nov 18 1998 - 11:30:57 CST
 |
 |