Oracle role: CONNECT

select
   privilege,
   admin_option
from
   dba_sys_privs
where
   grantee = 'CONNECT';
--   
-- PRIVILEGE                                ADM
-- ---------------------------------------- ---
-- SET CONTAINER                            NO 
-- CREATE SESSION                           NO 

select count(*) from dba_tab_privs where grantee = 'CONNECT';
--
-- COUNT(*)
-- --------
--        0