Originally posted by mfarouk
I think the recommended number of roles to achieve good performance is 80, thanks. [/B]
May I ask where did you get this magic number 80? And what influence on the performance the number of granted roles could possibly have? Can you provide any facts to support your assumption?
IMHO you've firstly invented an irrelevant question and then invented even more irrelevant answer for it....
My ansver to your question would be: users should be granted exactly those privileges that he needs to perform his job. No more and no less. In how many roles those privileges are spread depends on many factors. But the number of roles should have no particular influence on the performance.
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Firstly i would to thank u about your magic answer
1-for the 80 number is come from many discussion with oracle mans (DBA's and
DEVL) in big oracle offices.
2-For invented answer to may question ,because i want to discuss to number with
2- this for your vague answer.
And why do you have a better performance with 80 roles than with 20 or 100?
If the number of roles affect the performance, does the number of privileges also affects the performance?
Without proof that the number of roles does affect the performance, i don't think it does.
From all the perfomance tuning books, papers I have read none states that you can tune perfomance with number of roles, actually none of them states that number of roles affects perfomance, these are not vague answers. Simply we say what we have faced , seen experienced.
There is no such recommendation for your question, one example
if you need to grant 50 roles to many users you might as well create a role that contains those 50 roles. In this case how many role we have? One...
And actually if number of roles affect perfomance we are more than happy hearing why