Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: product_user_profile owner
How do I make sure that all the users other than "DBA" have only SELECT
privilege on this PRODUCT_USER_PROFILE?
> 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 Tue Jul 30 2002 - 07:21:27 CDT