http://qs1969.pair.com?node_id=470756


in reply to Re^7: DBI Password connection to Oracle
in thread DBI Password connection to Oracle

You are misreading what external is -- it just passes the auth that is submitted to oracle from a client to the OS for verification instead of using its internal user db. Or in the case of a local client (running on the same server as oracle server) then it allows users that have already authed to that server to use the databse (the OP states that there will be remote clients). from your link: If a user with an operating system account named tsmith is to connect to an Oracle database and be authenticated by the operating system... This means you are still passing username and password from the client perl script -- however on the oracle server side instead of authing against its own internal user db, it passes to the OS. There is nothing here that makes it magically not need a user or password on/in the client script.


-Waswas

Replies are listed 'Best First'.
Re^9: DBI Password connection to Oracle
by Transient (Hermit) on Jun 28, 2005 at 19:00 UTC
    Yes, I should have stated that my assumption was that the user was already logged in on the DB server (by whatever means) and this is tied to the user on the networked server. However, for a local system, no password is required to be passed to Oracle. See here:

    the idea is to make it so you don't have an oracle password at all. you log into the OS and the database trusts you are who the OS says you are.


    Granted it's all theory at this point (and trusting the documentation) and it's not documented on how to do this over a network - that part is pure speculation.

    What isn't speculation is that this is more an Oracle question than a Perl question and that Oracle has many ways to do this on its own :)
      The perl script is not local and therefor would need to send the user and password -- from the Original Post: I need to connect via some arbitrary machine known to my network either via cgi or back end perl scripts to a oracle DB.

      anyways I am bored of this thread and shutting down until the OP posts more info.


      -Waswas