Re: change users in the middle of a session?

CONNECT in SQL*Plus...

Forms 3 users can use switch-user key (Ctrl-X, or Ctrl-U).

I know this is not an effective-uid change. I know of no way to do that.

Good luck.

In your message dated Friday 29, December 1995 you wrote :
> Hello and happy new year!
>
> Is there a way in Oracle to change 'effective' userid's in the
> middle of a session? I'm interested in a SQL (i.e. something along
> the lines of ALTER SESSION) or a Pro*C- or OCI-specific solution,
> but if it can be done with any of the tools (SQL*Plus, etc) I
> should be able to figure it out :)
>
> Thanks,
>
> Omri (omri_at_pobox.com)

--

|   v___v    |                                John Thomas
|  / o-o \   |
|  \__Y__/   |                                E-Mail: John_at_toronto.demon.co.uk
| ( ~ ~ ~ )  |                                Tel: 0181 944 9858