Running System Privilege Authentication Tasks on the Client Computer

Learn about running system privilege authentication tasks on the client computer.

Perform the following steps:
  1. Log in as a Windows ___domain user who is a member of one of the Windows local group on the server, according to the system privilege that you want Windows to grant. The administrator must add this ___domain user to the required Windows local group. Windows local group membership is created on the server system where Oracle Database runs.
  2. Ensure that the parameter SQLNET.AUTHENTICATN_SERVICES in file sqlnet.ora contains nts.
  3. Use Oracle Net Configuration Assistant to configure a network connection from your client computer to the Windows server on which Oracle Database is installed.
  4. Start SQL*Plus:
    C:\> sqlplus /NOLOG
    
  5. Connect to Oracle Database:
    SQL> SET INSTANCE net_service_name
    

    where net_service_name is the Oracle Net net service name for Oracle Database.

  6. Enter either of the following SQL*Plus commands so that you connect to the database with the required system privilege:
    SQL> CONNECT / AS SYSOPER
    SQL> CONNECT / AS SYSDBA
    SQL> CONNECT / AS SYSASM
    SQL> CONNECT / AS SYSDG
    SQL> CONNECT / AS SYSKM
    SQL> CONNECT / AS SYSBACKUP
    

    You are now connected to the Windows server. If you connect with SYSDBA, you are given DBA privileges.