(1) REMOTE_LOGIN_PASSWORDFILE = none and SQLNET. AUTHENTICATION_SERVICES = none:
Oracle Installation User Local sqlplus "/as sysdba" cannot log on
Non-oracle Installation User Local sqlplus "sys/change_on_install as sysdba" cannot log on
Non-oracle Installation user remote sqlplus "/as sysdba_on_install @ sid as sysdba" cannot log on
(2) REMOTE_LOGIN_PASSWORDFILE = exclusive and SQLNET. AUTHENTICATION_SERVICES = none:
Oracle Installation User Local sqlplus "/as sysdba" cannot log on
Non-oracle Installation users can log on to the local sqlplus "sys/change_on_install as sysdba"
Non-oracle Installation user remote sqlplus "/as sysdba_on_install @ sid as sysdba" can log on
(3) REMOTE_LOGIN_PASSWORDFILE = none and SQLNET. AUTHENTICATION_SERVICES = (ETS ):
Oracle Installation allows you to log on to the local sqlplus "/as sysdba"
Non-oracle Installation User Local sqlplus "sys/change_on_install as sysdba" cannot log on
Non-oracle Installation user remote sqlplus "/as sysdba_on_install @ sid as sysdba" cannot log on
(4) REMOTE_LOGIN_PASSWORDFILE = exclusive and SQLNET. AUTHENTICATION_SERVICES = (ETS ):
Oracle Installation allows you to log on to the local sqlplus "/as sysdba"
Non-oracle Installation users can log on to the local sqlplus "sys/change_on_install as sysdba"
Non-oracle Installation user remote sqlplus "/as sysdba_on_install @ sid as sysdba" can log on