Re: switch user inside sqlplus

[Quoted] 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.

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Feb 3 16:45:38 2007

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> conn sh/sh
Connected.
SQL> conn / as sysdba
Connected.
SQL> conn scott/tiger
Connected.
SQL> conn system
Enter password: *********
Connected.
SQL> conn oe/oe
Connected.
SQL>

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org