Re: switch user inside sqlplus

On Feb 3, 6:46 pm, DA Morgan <damor..._at_psoug.org> wrote:
> bofh1..._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
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Thank you. Just what I need. Received on Sun Feb 04 2007 - 17:59:17 CET