Re: Secure access to database application



Peter Ashford wrote:
Just looking for a bit of advice. I have an muti-user application
that I'm developing that talks to an Oracle database. What's the best
way (or at least a good way!) of securing user + password access to
the program? I've currently got a user table in the database and I
fetch whether the login credentials match what's in that table - but I
log in as an admin user to the DB in order to fetch the user table, so
admin password is coded into the application - this is obviously
bad.

Ideas? I presume there's a standard way of doing these kinds of
things :o)

The best solution would be if each user got real database
usernames/passwords and simply connected with those.

The next best solution is probably if the initial connection
to check the access used a username/password that only gave
access to run some check & lookup code that are only available
for running not for viewing.

Arne
.



Relevant Pages

  • Re: Oracle Connection Pool Problem
    ... and then restarts your service when it comes back online? ... I have used the oracle connection pooling as default. ... as> my oracle database would be down for backup every night. ... I know this is becoz the previous connections pooled are no longer> valid due to the shutdown of Oracle database. ...
    (microsoft.public.dotnet.languages.csharp)
  • System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
    ... I am having problems opening a connection to an Oracle Database using ... I can create the connection fine using the new connection wizard and ... The Application is on a server running Oracle 9i, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to import a .DMP file?
    ... I have received a .DMP file of an Oracle database. ... That is not an imp error, but a connection error. ... UNIX/Linux local connection -- ... $ imp user/pass file=... ...
    (comp.databases.oracle.tools)
  • Accessing Oracle
    ... I'm having a problem connecting to an Oracle database using C#. ... I have a user id:"UID" ... I can find snippets of code on the web but am confused as to what refernces to match up with what connection strings. ... Iwas wondering if anyone had a short bit of code, showing from start to finish a C# connection to an Oracle database. ...
    (microsoft.public.dotnet.languages.csharp)
  • Acessing Oracle
    ... I'm having a problem connecting to an Oracle database using C#. ... I have a user id:"UID" ... I can find snippets of code on the web but am confused as to what refernces to match up with what connection strings. ... Iwas wondering if anyone had a short bit of code, showing from start to finish a C# connection to an Oracle database. ...
    (microsoft.public.data.odbc)