Re: Question About Oracle Users

Nuno,

Interesting you mention roles.

The only problem I have come across (and I can't compete with TK on number of users) is where APPLICATION code has decided to use data dictionary views to check the database roles that a user has - and use them to decide on which bits of application functionality are allowed.

The drawback to this is that roles are in the same table as users, and finding 20 roles out of 10,000 users through the data dictionary views results in some very expensive and peculiar execution plans.

It comes back to a discussion you were in a while back about optimizer_mode and data dictionary views. It is my opinion that application code should NEVER use data_dictionary views - views are things that you design as part of an application.

The views designed for one application (e.g. the application for managing the database) are not guaranteed to be efficient for use in another application (e.g. the end-user application).

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Nuno Souto wrote in message <3b220301.4189775_at_news-server>...


>On Fri, 08 Jun 2001 15:30:27 -0400, Thomas Kyte <tkyte_at_us.oracle.com>

>wrote:

>

>>ops$tkyte_at_ORA8I.WORLD> select count(*) from all_users;

>>

>>  COUNT(*)

>>----------

>>     43363

>>

>

>

>Yikes!  You running standard sql.bsq for all that?  With roles and so

>on? That's excellent.

>

>Cheers

>Nuno Souto

>nsouto_at_bigpond.net.au.nospam

>http://www.users.bigpond.net.au/the_Den/index.html