RE: Performance issues from a large number of grants

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Sun, 30 Aug 2015 20:32:56 -0400
Message-ID: <06de01d0e384$9558d700$c00a8500$_at_rsiz.com>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Aug 31 2015 - 02:32:56 CEST