switch user inside sqlplus

[bofh...@hotmail.com]

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.

[DA Morgan]

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
damo...@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

[Oradba Linux]

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

This can provide you a good start.

[bofh...@hotmail.com]

On Feb 3, 6:46 pm, DA Morgan <damor...@psoug.org> wrote:

> damor...@x.washington.edu

> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Thank you. Just what I need.

[Oradba Linux]

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