Database Administration (MOSC)
MOSC Banner

Switch to another user within sqlplus

edited Oct 17, 2019 1:43PM in Database Administration (MOSC) 9 commentsAnswered ✓

Hello,

Oracle 11.2

How can I switch to another user in sqlplus when I connected using Os authentication as Oracle.

$> sqlplus / as sysdba

SQL> connect CUSTOMER;

Enter password:

ERROR:

ORA-01005: null password given; logon denied

When it prompted for password I just pressed enter. Should I specify sys password or maybe there is other way to switch ?

I do not know password for sys and CUSTOMER user.

Thanks in advance,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center