Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: the user pseudo-column
The username is in the v$session table.
I wouldn't recommennd trying to change it in your production DB though!
Try it in personal oracle.
Mark
robin_soderstrom_at_my-deja.com wrote in message
<7l7dbi$c1l$1_at_nnrp1.deja.com>...
>Hi all...
>
>I just wondering if anyone knows where the server gets the username in
>the pseudo column 'user', for instance if you run "select user from
>dual" you get the logged in user. Does the server take this name from a
>v$-views or dba-views or is it grabbing this name from the memory? And
>is it possible to change this username within a session?
>
>Regards,
>Robin
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Mon Jun 28 1999 - 04:30:23 CDT