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

On Wed, 04 Jun 2003 15:04:03 +0200, "Dr. Holger Peine" <peine_at_iese.fraunhofer.de> wrote:

>One or two roles per row: One role "Users allowed to write this row"
>and sometimes a second role "Users allowed to read this row".
>Does that make sense?

No. It doesn't make any sense.
You are misunderstanding and misusing roles. There also is a hardcoded upper limit of 128 or 512 roles per instance.
Please look into Virtual Private Database or Fine Grained Access Control or whatever marketing term Oracle uses for the feature in your version.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jun 04 2003 - 12:47:51 CDT