Results 1 to 4 of 4

Thread: password file

  1. #1
    Join Date
    Jun 2003
    Posts
    45

    Unanswered: password file

    Hi all,

    is it possible to connect to remote database without a password file?

    Pls explain

    regards
    sudheer

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Yes, It is possible.

    It requires Secure connection and Operating system Authentication for you to be remotely access the databse as an privileged user.
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  3. #3
    Join Date
    Jan 2004
    Location
    Singapore
    Posts
    89

    connect to oracle without password

    If you are using an unix id, say for example ppr, the u can connect to oracle database just by typing sqlplus /
    Because it takes oracle id as OPS$PPR. Some configuration has to be set up for this, but its possible.
    Thanks and Regards,

    Praveen Pulikunnu

  4. #4
    Join Date
    Jan 2004
    Location
    India
    Posts
    113

    Thumbs up

    There are two parameters that needs to be set in the init<sid>.ora file for OS authentication.
    a. Os_authent_prefix=
    b. Remote_os_authent =True

    Then execute a query to find out how oracle expects the OS user
    SQL> select osuser from v$session where username = 'SYSTEM';

    Lets assume that u receive the following output

    OSUSER
    ------------------------------
    DOMAIN\test


    SQL> create user "DOMAIN\TEST" identified externally;

    User created.

    Make sure you keep the hostname and username in capitals.

    SQL> grant connect, resource to "DOMAIN\TEST";

    Grant succeeded.

    Granted the privileges above.

    SQL> conn /
    Connected.
    SQL>

    Now from the client side Log into your machine with the username you have created ,make sure that your client connects to Oracle server
    ie proper service should be created in your client machine (Proper
    Entries should be there in the Tnsnames.ora file that resides in
    Oraclehome\network\admin.)
    After logging into the client machine with username you have created
    at the Sql prompt give /@connect_string.


    Above are steps need to follow for Windows authentication of users connecting to oracle server.

    Cheers
    Kaushik

Posting Permissions

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