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.
2019-07-21, 842👍, 0💬
Popular Posts:
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
What is Microsoft SQL Server in SQL Server? Microsoft SQL Server is a relational database management...
How To Count Duplicated Values in a Column in SQL Server? If you have a column with duplicated value...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...