Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> product_user_profile owner

product_user_profile owner

From: Joe Philip <joephilip2002_at_comcast.net>
Date: Tue, 30 Jul 2002 03:05:10 GMT
Message-ID: <Gnn19.386305$Im2.20123291@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:05:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US