Re: Only one Account for all users - How bad it is ?
Date: 1996/03/09
Message-ID: <4hs643$40m_at_platon.riq.qc.ca>#1/1
>The biggest problem I see is an administrative one. How will you
>determine which user is which? Especially when operations wants to shut
>down and there is one lone user still active.
>From the applications perspective, they shouldn't care what the user name
>is as long as they have the proper access to the files. That can be done
>with roles.
I completly agree with this. This is your worst problem. Also you won't be able to fine tune the security, the quota, the role and the profile for each of your user. Suppose one user want SQL*PLUS be you don't want that a ressource intensive query bring the database serve to hits knees, you won't be able to control the profile of this user in order to limit the CPU, I/O etc... for one session or one statement. I think one Oracle user for every body is really not a good solution. A long time ago I was at a site where the used only one Oracle account and I wouldn't do that again. Received on Sat Mar 09 1996 - 00:00:00 CET