DBAs can authenticate to the database through the operating system rather than with a database user name and password.
oracle database training courses malaysia
To enable operating system authentication of an administrative user:
- Create an operating system account for the user.
- Add the account to the appropriate operating-system defined groups.
oracle cloud infrastructure training courses malaysia
Connecting Using Operating System Authentication
A user can connect to the database using operating system authentication.
You can use operating system authentication by performing one of the following actions.
- CONNECT / AS SYSDBA
- CONNECT / AS SYSOPER
- CONNECT / AS SYSBACKUP
- CONNECT / AS SYSDG
- CONNECT / AS SYSKM
nodejs training courses malaysia
For the Windows platform only, remote operating system authentication over a secure connection is supported. You must specify the net service name for the remote database:
CONNECT /@net_service_name AS SYSDBA
CONNECT /@net_service_name AS SYSOPER
CONNECT /@net_service_name AS SYSBACKUP
CONNECT /@net_service_name AS SYSDG
CONNECT /@net_service_name AS SYSKM
Leave a Reply