look at dba_role_privs and dba_sys_privs. On Mon, May 18, 2009 at 10:34 AM, dba1 mcc <mccdba1@xxxxxxxxx> wrote: > > For ORACLE 9iR2 and 10G does there has way to check which privilege grant > to "public". For example "grant create session to public;". > > I have been check "dba_role_privs" and can not find it. > > > Thanks. > > > > -- > //www.freelists.org/webpage/oracle-l > > > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'