Hi everyone,
I'm currently reviewing Oracle security model. I'm currently revieving roles and privileges. I've read in the doucmentation (1) that every single privilege granted to PUBLIC is granted to every other users. But I was wondering if I can see all the privileges granted to PUBLIC by default.
When I do this:
SELECT *
FROM dba_sys_privs
WHERE grantee = 'PUBLIC';
I don't get any result. So, I was wondering how can I list all the privileges granted to public?
Thanks,
(1) http://download.oracle.com/docs/cd/E18283_01/network.112/e16543/authorization.htm#BABHJFCF