Re: Public synonyms

A grant to PUBLIC. A synonym just means you don't have to preface the owner of the object.

Terry

Kristen Cameron wrote:

> I'm using Oracle 7.3.4 on Solaris 2.7. I recently created a view in a particular schema, then created a public synonym for that view. However, the user who needed it was unable to access it until I granted them select privileges on the view. This user has create session privileges, and a number of object privileges assigned via a role.
>
> I thought that creating a public synonym made the object available to all users. What am I missing?
>
> I've resolved the problem by granting the user select privileges on the view, but I still don't understand why I needed to do that. I thought that creating a public synonym made the object available to all users. What am I missing? Can anyone explain it to me?
>
> Thanks!
>
> ~~~~~~~~~~~~~~~~~~~~~~~~
> Kristen Cameron
> Database Administrator
> Indian and Northern Affairs Canada
> P.O. Box 1500
> Yellowknife NT X1A 2R3
>
> 867-669-2536
> ~~~~~~~~~~~~~~~~~~~~~~~~~~
> <>< Micah 6:8
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kristen Cameron
> INET: cameronkgd_at_inac.gc.ca
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Nov 16 2000 - 11:14:20 CST