sys user pwd Understanding as sysdba
os : linux
oracle : 10.2.0.3
I am able to connect sys as sysdba No problem.
on Server terminal : sys is working with any pwd as sysdba.
SQL> connect sys/gln as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL> connect sys/a as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL> connect sys/b as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL>
However if we connecting thru tnsnames it is validataing not allowing.
How to understand this.
connect sys/anypwd as sysdba is just nothing connect / as sysdba ?
SQL> connect system/anypwd as sysdba
Connected.
SQL> show user
USER is "SYS"
So sysdba is not a previlege but a role?
pl. clarify.