How would you handle this USER scenerio???

From: NNOOR <Nnoor_at_cris.com>
Date: 1997/10/22
Message-ID: <62kr2e$jr0@examiner.concentric.net>#1/1

I am writing a C/S app using Delphi 3 c/s and Oracle 7.3 on win NT. There will eventually be hundreds of users everyone looking at just their "own" records. I am faced with a dilemma here when it comes to set up these users on the Oracle and my application.

I have two choices:
A. Give every user a userid on the Oracle itself. Assign every one a common role which gives them access to the application schema's objects. My application will then maintain a list of authorized users in a table along with the details it needs to know.

B. Create one "behind the scenes" id on the oracle which applicatoin uses to connect to Oracle. Then validate the user typed id and password against the list maintained by the application in a table. Using this approach, every application user does not become a user on ORACLE itself.

Would you help me pick one of these two scenerios?

Thanks a lot!!!

Regards,
Nasir (nnoor_at_cris.com) Received on Wed Oct 22 1997 - 00:00:00 CDT