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;
Connected.
SQL> show user;
USER is "SYS"

What is the difference between logging as sqlplus / as sysdba and the above command. How  oracle internally logs them as sys user?
sam_2012Asked:
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:
https://docs.oracle.com/database/121/ADMQS/GUID-2033E766-8FE6-4FBA-97E0-2607B083FA2C.htm#ADMQS12004
0
 
sam_2012Author Commented:
awesome
0
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.