RE: Privileges granted by roles

  • From: Sayan Sergeevich Malakshinov <malakshinovss@xxxxxxxxx>
  • To: JDunn@xxxxxxxxx
  • Date: Tue, 21 Apr 2015 12:59:51 +0300

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
Mobile: +7(903)207-1576
Tel: +7(495)777-1020 add (775956)

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2015