Re: Question About Oracle Users

"Daniel" <dhw377_at_usa._NO_SPAM_.net> wrote in message news:rhVT6.14166$e34.4668131_at_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.
>
>

Please go ahead ruining your already desupported database. You want to delete directly from all_users? Ha!
Know anything about Oracle?
Why on earth do you want to do this?
Why don't you just drop these user? This is the only way to get rid of them in all_users, but they won't be able to connect anymore. 50.000+ users on *1 single* desupported database? You can't be serious, or your department wants to potentially ruin your company.

Regards,

Sybrand Bakker, Oracle DBA Received on Thu Jun 07 2001 - 23:09:04 CDT