Re: Is it possible to create a user without PUBLIC role?

"Jimmy" <anonymous_at_anonymous.com> wrote in message news:3962E057.BE847DA4_at_anonymous.com...
>
>
> Is it possible to revoke privileges granted to PUBLIC from a user?
> This is because when I create a new user, this user automatically has
> all the privileges granted to PUBLIC. However, I do not want this user
> has all the privileges granted to PUBLIC. I have tried "revoke PUBLIC
> from new_user" but failed. What can I do such that I can create a user
> without the PUBLIC role granted to him?
>
> Jimmy
>

Whenever you grant a privilege public all users will have that privilege automatically. That's the *sole purpose* of PUBLIC. Internally any privilege check includes a check for PUBLIC.
PUBLIC is *not* a role, it is a *special user* that already existed in Oracle 5, you can't grant or revoke PUBLIC to an user. If you don't want everyone receiving privilege automatically, you'll need to revoke the privilege from PUBLIC and grant it to users individually or grant it to a role (PUBLIC is *not* a role) and grant that role to users.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Jul 04 2000 - 00:00:00 CDT