469,334 Members | 4,335 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,334 developers. It's quick & easy.

How tough can I be for the user PUBLIC?

Hello guys!

Bear with me,I am newbie.

I am trying to limit the privileges of the user PUBLIC has as toughly
as possible which means I want to go as far as I can then leave those
MUST-HAVE privileges for user PUBLIC. The question is how far I can
go?

My expectation is once I have done this and I am asked to let my Data
Warehouse users to access the database with only select privileges on
some tables, what I need to do will be creating a role "USER_READ"
with
1. CREATE SESSION and ALTER SESSION system privileges
2. Select privilege on certain user tables as object privileges
then I put all those users in this role.

So, what should I have least for privileges of user PUBLIC then, if I
ask the question in another way?

Cheers!

Gary
Jul 19 '05 #1
1 5942
ro************@yahoo.com.au (Gary) wrote in message news:<17**************************@posting.google. com>...
Hello guys!

Bear with me,I am newbie.

I am trying to limit the privileges of the user PUBLIC has as toughly
as possible which means I want to go as far as I can then leave those
MUST-HAVE privileges for user PUBLIC. The question is how far I can
go?

My expectation is once I have done this and I am asked to let my Data
Warehouse users to access the database with only select privileges on
some tables, what I need to do will be creating a role "USER_READ"
with
1. CREATE SESSION and ALTER SESSION system privileges
2. Select privilege on certain user tables as object privileges
then I put all those users in this role.

So, what should I have least for privileges of user PUBLIC then, if I
ask the question in another way?

Cheers!

Gary


PUBLIC isn't a real user, it is a dummy user. It is from the days
roles didn't exist. You can't connect as PUBLIC. Hence, if you don't
grant privilege to PUBLIC nothing will happen. I'd suggest you would
leave public alone. Simply don't grant privilege to public.

Sybrand Bakker
Senior Oracle DBA
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

198 posts views Thread by Sy Borg | last post: by
6 posts views Thread by Kennedy_f | last post: by
5 posts views Thread by Dot net work | last post: by
4 posts views Thread by Just Me | last post: by
24 posts views Thread by Karen Hill | last post: by
1 post views Thread by kev | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by haryvincent176 | last post: by
reply views Thread by Marylou17 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.