How to switch from one user to another in sqlplus

Posted on May 29, 2013 by Ahmed Tawfik

for example, you’re connected as sysdba using “sqlplus / as sysdba”, all you have to do is type “connect”, then enter the desired username and password, and there you go!

Unknown's avatar

About Ahmed Tawfik

Cybersecurity Professional, Systems Engineer, OSS & Linux Geek
This entry was posted in Uncategorized and tagged , , , . Bookmark the permalink.

2 Responses to How to switch from one user to another in sqlplus

  1. pavanpro's avatar pavanpro says:
    October 5, 2013 at 7:52 am

    CONNECT USER_NAME;
    It’l prompt for password: enter your password

    Liked by 1 person

    Reply
  2. samajap ni sadnap's avatar samajap ni sadnap says:
    September 1, 2020 at 11:13 pm

    Also, you’ll need to make sure the user has been granted the create session privilege:
    GRANT CREATE SESSION TO user_name;
    Without that, the user can’t log on (i.e. create a session), and therefore you can’t log on as that user.

    Like

    Reply

Leave a comment