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.