Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8 USERS_SESSIONS ???
clifford buetikofer wrote:
> I used to use the following SQL in my 7.3.2 database to get the OSUser
> string, but in Oracle 8 it no longer works:
>
> Select osuser from user_sessions
> where audsid = userenv('SESSIONID');
>
> I've been digging through the Oracle 8 docs but no luck. Has anybody
> found what happened to the user_sessions object ?
>
> Cliff
> (clifford_buetikofer_at_merck.nospam.com)
>
> The contents of this message express only the sender's opinion.
> This message does not necessarily reflect the policy or views of
> my employer, Merck & Co., Inc. All responsibility for the statements
> made in this Usenet posting resides solely and completely with the
> sender.
Hi Clifford
There is no table or view called user_sessions in Oracle 7.3. The view that u are talking about is V_$SESSION and not user_sessions.
Thanks
Sai
Received on Tue Dec 08 1998 - 09:25:03 CST