RE: Performance issues from a large number of grants

On 2015/08/30 19:32, Mark W. Farnham wrote:

> Other than during the actual granting of the grants, this should create only
> the most trivial of differences during the parse phase and should amount to
> nothing significant.

My empirical evidence to back that up is a role with over 40,000 grants with no performance hit that I've seen (11.2.0.3.8 on AIX).

My $.02,
Rich

--
http://www.freelists.org/webpage/oracle-l