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

peine_at_iese.fraunhofer.de (Holger Peine) wrote in message news:<cd219406.0306040154.2dca5d1d_at_posting.google.com>...
> Hello,
>
> 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 maybe 10,000 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). Of the 500 users, maybe 20 are connected at the same
> time (on the average). Is this sensible from point of view of
> performance?

10,000 (Oracle) roles for 500 users and a role for every row? Either you are referring to something else or have no idea what Oracle role is.

Regards
/Rauf Sarwar Received on Wed Jun 04 2003 - 10:07:30 CDT