Question About Oracle Users

From: Daniel <dhw377_at_usa._NO_SPAM_.net>
Date: Fri, 08 Jun 2001 00:48:23 GMT
Message-ID: <rhVT6.14166$e34.4668131@typhoon.southeast.rr.com>

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 Thu Jun 07 2001 - 19:48:23 CDT