Re: Question About Oracle Users

It's probably more efficient to leave it as is. And more secure. If security and quality assurance is of any concern, it's best to have users connecting to their own account rather than to a group account which implements it's own authentication with it's own user/password table. Leaving the 50000 accounts as is will let you take advantage of rdbms auditing features, password profile features, etc.

Daniel wrote:
>
> Currently, our system has about 50,000+ Oracle users. That is, there are
> 50,000+ entries in the system table, "all_users". I am trying to determine
> if this is the best and most efficient way to do this. Would it take less
> resources and make the database go faster if I deleted all these Oracle
> users and instead just put their info into a new user created table with
> their username and password?
>
> So, I delete all the Oracle users, create a new table called Users, with two
> columns (username, password), and insert 50,000+ rows into this table.
>
> I believe I am using Oracle 8.04 (not 8i).
>
> Thanks in advance.
Received on Fri Jun 08 2001 - 06:19:33 CDT