Collections:
Use SYS Account to Connect to the Server in Oracle
How To Connect to the Server with User Account: SYS in Oracle?
✍: FYIcenter.com
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 Connected. 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
2019-07-21, 1724🔥, 0💬
Popular Posts:
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...