Using Oracle security

  • Thread starter Thread starter Paul Speranza
  • Start date Start date
P

Paul Speranza

I have a web app that needs to work with a PowerBuilder app's database. This
means sharing tables for user rights and other such things. The PB app uses
Oracle's logons so the user id and password are passed in the connection
string. To authenticate a user they are telling me to get the id and
password and try to connect to Oracle and trap an Oracle exception if the
connection fails because of invalid credentials.

Is there a better way to find out if the user is valid in the Oracle
database? Our current database has our own table for users so this is not an
issue in the web app, but we are combining databases and would like to have
the PB app maintain users, which means my tables wil go away. We don't want
to maintain two ways of logging on.


Regards,
Paul Speranza

http://weblogs.asp.net/Psperanza/
 
Hi Paul,

Thank you for posting in the community!

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to check if the logon
credential is valid to the Oracle server without trying to connect to the
server and catch exception. If there is any misunderstanding, please feel
free to let me know.

As far as I know, we cannot check if the user name and password are valid
without connecting to the server. So we need at least one credential to
connect to it. If we only have the credential that we don't know whether it
is valid or not, I think the only way of checking is to connect to the
server and catch the exception. If you have another user's credential, such
as the database administrator, I think there might be a way of checking, by
first loggin on with the administrator's credential. However, this depends
on the feature of Oracle.

As this issue has much relationship with the Oracle database, besides
posting here, you can also contact Oracle support for help. Here is a link:

http://support.oracle.com

If anything is unclear, please feel free to reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Back
Top