Re: switch user inside sqlplus

From: Oradba Linux <oradba_linux_at_verizon.net>
Date: Sun, 04 Feb 2007 03:43:07 GMT
Message-ID: <fDcxh.17907$h75.15040_at_trnddc01>


bofh1234_at_hotmail.com wrote:
> Hello,
>
> Is there a way to login to sqlpus (sys as sysdba), create a user with
> appropriate privileges, and then switch to that user without leaving
> sqlplus? Something like the su command in Linux? I am working on a
> script that has to used by a person who has not used a database before
> (long story).
>
> Thanks,
>
> P.S. I am not an oracle expert.
>

http://asktom.oracle.com/tkyte/Misc/su.html

This can provide you a good start. Received on Sun Feb 04 2007 - 04:43:07 CET

Original text of this message