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.
mwf
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Schauss, Peter (ESS)
Sent: Friday, August 28, 2015 4:30 PM
To: oracle-l
Subject: Performance issues from a large number of grants
This is Oracle 11.2.0.4 running on Red Hat Linux.
We have a some accounts which are used exclusively for reporting and require
select access to large numbers of tables in the application databases. My
predecessors were lazy and granted SELECT ANY TABLE to these users. I am
looking to convert these into explicit grants via roles where possible. Is
there going to be a significant performance penalty for doing it this way?
Thanks,
Peter Schauss
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
