Re: Performance issues from a large number of grants

From: Vishal Gupta <vishal_at_vishalgupta.com>
Date: Sun, 30 Aug 2015 18:37:45 +0100
Message-ID: <D5D76947-D584-4B17-B063-1D5E980EB55C_at_vishalgupta.com>

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_at_freelists.org> on behalf of "Schauss, Peter (ESS)" Reply-To: <peter.schauss_at_ngc.com>
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
>--
>http://www.freelists.org/webpage/oracle-l
>
>

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

Received on Sun Aug 30 2015 - 19:37:45 CEST