Swaminathan K
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER