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 -> Re: product_user_profile owner

Re: product_user_profile owner

From: <Christopher.Jones_at_oracle.comX>
Date: 30 Jul 2002 14:03:03 +1000
Message-ID: <uwurdj214.fsf@oracle.comX>


"Richard Foote" <richard.foote_at_bigpond.com> writes:

Joe,

If you want to verify for yourself how the PRODUCT_USER_PROFILE "table" was created and the permissions granted, look at the $ORACLE_HOME/sqlplus/admin/pupbld.sql script.

Chris

> 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?
> >
> >
> >
> >
>
>

-- 
Christopher Jones, Oracle Corporation, Australia.
Received on Mon Jul 29 2002 - 23:03:03 CDT

Original text of this message

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