Re: 500 users, 10,000 roles: Performance problems to be expected?

From: Rajiv Gangadharan <rajiv_gangadharan_at_sancharnet.in>
Date: Tue, 10 Jun 2003 23:28:10 -0700
Message-ID: <bc58so$fjuts$2@ID-176666.news.dfncis.de>

> I'm designing the user/role/privilege security for an existing Oracle
> 8i database accessed through an application server (Bea Weblogic). So
> far, the AS uses one DB user for all accesses, i.e. end users are
> managed in the AS only, not in the DB.

>
> I plan to change that and make a dedicated account for each end user
> (about 500) plus

If you have 500 users, making 500 users makes sense to me.

> maybe 10,000 roles

Why do you need to create roles ?

> (one role per user and a few roles
> per row in the central data table, which is expected to hold a few
> thousand rows).

I am not able to understand this, how is role connected with rows in a table.

> Of the 500 users, maybe 20 are connected at the same
> time (on the average). Is this sensible from point of view of
> performance?

The above is not in any way related to your original problem/issue/question. Received on Wed Jun 11 2003 - 01:28:10 CDT