Re: Question About Oracle Users

I just describing what is in place at the current moment. Perhaps you did not understand what I was really trying to say. My question is, is it better to have 50,000 Oracle users and validate them when they try to connect to the database with their username and password ..... OR ..... connect to the database with some same master Oracle user and then check the client's username and password in a user defined table?

Perhaps I should have phrased my question this way.

I want to know if there are any issues with having 50,000 Oracle users, performance-wise, etc.

Thanks,
Daniel

PS. When I mean't deleting users, I meant dropping them.

> 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 Fri Jun 08 2001 - 03:57:55 CDT