Performance issues from a large number of grants
From: Schauss, Peter (ESS) <"Schauss,>
Date: Fri, 28 Aug 2015 20:29:46 +0000
Message-ID: <ea9477d8e3aa499ba75bae22f3d19808_at_XCGVAG22.northgrum.com>
This is Oracle 11.2.0.4 running on Red Hat Linux.
Date: Fri, 28 Aug 2015 20:29:46 +0000
Message-ID: <ea9477d8e3aa499ba75bae22f3d19808_at_XCGVAG22.northgrum.com>
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-lReceived on Fri Aug 28 2015 - 22:29:46 CEST