Re: How would you handle this USER scenerio???

Hi Nasir,
Hi Joseph,

We have also the same problem resolved (1800 people on our application)

Only 20 people were subscribed on Oracle because they need more resources and controls on data.

Other people use an Client-Server application (Server written in Pro*C, Clients with C on Unix, VB & Winsock on PC). This is possible because the server knows all requests usable (with variables to adapt queries, updates and inserts)

In our case, the Server and the Clients get all parameters in Oracle's tables (easy to maintain with a form accessible by Application Administrators who are not DBA nor Unix Administrator)

This development is not too heavy. It's a way between Oracle's tools and weight of administrating.

1. No suspicious activities because all requests are written by application
2. Minimum CPU charge because Server release socket at each call (it's a fabulous gain of charge !). Many requests take a few time because they were fully optimised and stored in cache.
3. No locks possible because Server close always the transactions. A full logbook trace calls in our case.

Hope this helps

--
REIP Jean-Claude
Enlevez ".remove.this" de l'adresse (anti-spam)
jacari.consultant.remove.this_at_skynet.be
Joseph D. Sumalbag wrote in message <344E5F84.3EFB_at_bose.com>...


>NNOOR wrote:

>>

>> 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.

>

>   1.) How would your do about auditing each user in case there

>are suspicious activities on the database ?

>

>   2.) If you are restrict the connect time of a particular

>user, His CPU USE , his profile . Once you edit the profile

>everyone will get affected . So you can't do it ,

>

>   3.) You want to investigate or view how the user sends the

>transactions , or whos locking what ? , who is using which

>table, who is sending the SQL calls ......

>

>Joseph

>Unix/NT Oracle DBA