DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 17

Thread: ORA-01031 Insufficient privilege when connecting from client

Threaded View

  1. 01-09-2003, 11:52 AM #12
    supower's Avatar
    supower
    supower is offline Working member
    Join Date
    Dec 2002
    Location
    USA
    Posts
    53
    I forgot you are in win2000. Please set
    SQLNET.AUTHENTICATION_SERVICES= (NTS)
    so you can locally connect to internal w/o passwd if you login in as oracle owner or local admin.

    There is security concern here, if set
    SQLNET.AUTHENTICATION_SERVICES= (NTS)
    and REMOTE_LOGIN_ PASSWORDFILE=exclusive in Wins.
    You can connect sys/ANYPASSWD@SID as sysdba.
    So oracle suggest that, if set
    SQLNET.AUTHENTICATION_SERVICES= (NTS) in Wins,
    set REMOTE_LOGIN_PASSWORDFILE=NONE to avoid remote connection as sysdba.
    Last edited by supower; 01-09-2003 at 11:57 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width