Re: Privileges granted by roles

From: Tim Gorman <tim_at_evdbt.com>
Date: Tue, 21 Apr 2015 06:36:47 -0600
Message-ID: <5536445F.70608_at_evdbt.com>



Seconding what Sayan said. CONNECT and RESOURCE are just roles, albeit pre-populated by Oracle. Their contents have varied over versions, and some DBAs have taken it unto themselves to change them as they wish or prefer. It is best not to assume, and instead verify what they contain.

Pete Finnigan's script "find_all_privs.sql" (found on this page <http://www.petefinnigan.com/masterclass.htm>) could be useful for questions such as these.

On 4/21/15 3:59, Sayan Sergeevich Malakshinov wrote:
> Hi John,
>
> you can check the real privileges for CONNECT and RESOURCE:
>
> select * from dba_sys_privs p where p.GRANTEE in ('CONNECT','RESOURCE');
>
> --
> Best regards,
> Sayan Malakshinov
> Oracle ACE Associate, Oracle performance tuning expert
> Promsvyazbank PJSC http://psbank.ru <http://psbank.ru/>
> Mobile: +7(903)207-1576
> Tel: +7(495)777-1020 add (775956)

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 21 2015 - 14:36:47 CEST

Original text of this message