Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Privileges granted to PUBLIC

user13117585Apr 3 2011 — edited Apr 3 2011
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2011
Added on Apr 3 2011
2 comments
511 views