understanding on how oracle logs in sys user for the command SQL> connect system/orcl@pdborcl1 as sysdba

Hi Team,

I want to understand how oracle internally treats the below credentials as sys and logs into the database as sys user.

SQL> connect system/orcl@pdborcl1 as sysdba;
SQL> show user;

What is the difference between logging as sqlplus / as sysdba and the above command. How  oracle internally logs them as sys user?
Who is Participating?
slightwv (䄆 Netminder)Connect With a Mentor Commented:
I'm not sure I'm understanding what you are asking.

sysdba is a very special system privilege.  Depending on how you have your system configured, you don't even need a valid username and password on the database server.  Assuming you don't have a fred user in your database:
connect fred/flintstone as sysdba;

You still connect as SYS.  The "/" uses OS authentication to see if the OS user has permission to connect as SYSDBA.

I would read the online docs for the specifics:
sam_2012Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.