Re: Code Needed to log on the Oracle automaticly

From: '69 Camaro (ForwardZERO_SPAM.To.69Camaro_at_Spameater.orgZERO_SPAM)
Date: 12/29/04


Date: Wed, 29 Dec 2004 08:48:31 -0800

Hi, Ken.

> Need code to log the Oracle Database automaticly without type in the
Oracle
> User Name and Password.

Are you planning to store this Oracle User ID and password in an Access
database, perchance? If so, for your own personal safety, please put this
thought out of your mind. As an Oracle DBA myself, I can tell you that I
don't know of any Oracle DBA -- who has worked long and hard to secure an
Oracle database -- who wouldn't go ballistic when he found out that an
Access database developer couldn't be trusted with the knowledge of a User
ID and password.

For security reasons, the user _must_ authenticate at least once per user
session by typing a User ID and password. Your application can hold these
values in variables, but do not store the User ID and password in the Access
database.

If you choose otherwise, be prepared for many dents in your health record.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

"Ken" <Ken@discussions.microsoft.com> wrote in message
news:D090ED7D-5685-4926-87DA-55FBFFE6F413@microsoft.com...
> Need code to log the Oracle Database automaticly without type in the
Oracle
> User Name and Password.



Relevant Pages

  • Re: design question
    ... I need to store java objects in my oracle database. ... The database shall scale up at least to 100 million objects. ... storage to relational theory is to shred XML into its constituent ...
    (comp.databases.oracle.server)
  • Re: What so special about PostgreSQL and other RDBMS?
    ... That's exactly the link the licence agreement for the database points to when it ... comes to what wecan expect for paying support. ... > "Oracle may provide additional releases or versions of its programs ... If the requirements are volatile I'd do a long term contract detailing what ...
    (comp.lang.php)
  • ORACLE DBA -- Western Suburbs of Chicago
    ... OPERATIONAL ORACLE DBA ... DBA will work in the Oracle environment and help manage a complex ... with many constituencies to develop database solutions to business ... with a minimum of 3 years' of Oracle DBA experience. ...
    (comp.lang.python)
  • A cool DBA job wanted
    ... 7, Oracle 6, Sybase, SQL Server ... Proposed proactive database monitoring through ... strategies to administer remote Oracle databases ... Trained installation and support personnel in basic ...
    (comp.databases.oracle.server)
  • Re: I want to add to myknowledge
    ... 7, Oracle 6, Sybase, SQL Server ... Oracle Database Administrator ... Trained installation and support personnel in basic ... Senior Oracle Database Administrator ...
    (comp.databases.oracle.server)

Quantcast