Collections:
Use Windows User to Connect to the Server in Oracle
How To Use Windows User to Connect to the Server in Oracle?
✍: FYIcenter.com
During the installation process, 10g XE will create a special Windows user group called ORA_DBA, and put your Windows user into this group. Any Windows users in this group can be connected to Oracle server with SYSDBA privilege without any Oracle server user account. This process is called connecting the server as SYSDBA with OS Authentication. Here is how to do this with a special form of the "connect" command:
(Log in with the same user you used to install 10g XE) >cd (OracleXE home directory) >.\bin\startdb >.\bin\sqlplus /nolog SQL> connect / AS SYSDBA Connected. SQL> quit
So if "connect" is used without user name and password, the current Windows user will be trusted if he/she is in the ORA_DBA user group on the Windows system.
⇒ Show All User Accounts in Oracle
⇐ Use SYS Account to Connect to the Server in Oracle
2019-07-21, 1923🔥, 0💬
Popular Posts:
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...