Re: product_user_profile owner

Hi Joe,

Public means that this synonym is a "public" synonym and can be referred to by any database user.

Note only the synonym (or nickname) can be accessed by any database user, the underlining object can still only be accessed by users with appropriate privileges (such as select object privilege or select any system privilege).

Cheers

Richard
"Joe Philip" <joephilip2002_at_comcast.net> wrote in message news:Gnn19.386305$Im2.20123291_at_bin2.nnrp.aus1.giganews.com...
> When I do the following query:
>
> select owner, oject_name, object_type from dba_objects
> where object_name = 'PRODUCT_USER_PROFILE';
>
> I got the following o/p:
>
> owner Object_name Object_type
> PUBLIC PROUCT_USER_PROFILE synonym
> SYSTEM PROUCT_USER_PROFILE synonym
>
> Here, what does the owner Public mean?
>
> How do I make sure users other than DBA have only 'select' privilege on
> this?
>
>
>
>
Received on Mon Jul 29 2002 - 22:45:10 CDT