Re: How to change the USERID variable?

> Is there a way by using PL/SQL to change the USERID variable.
>
> We have people who will be consecutively sharing a permanently logged in
> connection and we would like to be able to reassign the variable as the
> connction gets allocated out to a user mainly so we can continue to use it
> in triggers etc that store the value USERID.
>
> I know I could achieve the same thing with a package variable but it would
> be a little bit neater if I could set the USERID var instead of creating my
> own.

You do not "change" the USERID. You CREATE them and DROP them. Look into the books for the CREATE USER and DROP USER commands.

Regards,

Daniel A. Morgan Received on Wed Aug 05 1998 - 23:32:57 CDT