Use SYS Account to Connect to the Server in Oracle


How To Connect to the Server with User Account: SYS in Oracle?



SYS is a very special user account. It has been associated with the highest privilege call SYSDBA. Normally, you should not connect to the server with SYS. But if you want to use it, you need to use a special connect command:

>cd (OracleXE home directory)
>.\bin\sqlplus /nolog

SQL> connect SYS/fyicenter AS SYSDBA

SQL> quit

Note that the "/nolog" option is used to start SQL*Plus without login immediately. A special form of the "connect" command is used to include the user name, password, and the privilege in the same line.

You can not log in with SYS without SYSDBA privilege.


Use Windows User to Connect to the Server in Oracle

Built-in Internal User Accounts in Oracle

Managing Oracle User Accounts, Schema and Privileges

⇑⇑ Oracle Database Tutorials

2019-07-21, 1764🔥, 0💬