Please keep in mind that if your reporting applications are running dynamic SQL
statements, then you would need to grant the SELECT privileges directly to
user. It won’t work via roles.
Regards,
Vishal Gupta
-----Original Message-----
From: <oracle-l-bounce@xxxxxxxxxxxxx> on behalf of "Schauss, Peter (ESS)"
Reply-To: <peter.schauss@xxxxxxx>
Date: Friday, 28 August 2015 21:29
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
