RE: Public synonyms

A public synonym just creates another name for that object. For example if you have a table called
tab owned by kristen then another user would have to

select * from kristen.tab;
when you create a synonym tab for kristen.tab then the user can select * from tab assuming you grant privs as you did.

Synonyms does not grant any privs on an object.

Rick

> -----Original Message-----
> From: Kristen Cameron [SMTP:cameronkgd_at_inac.gc.ca]
> Sent: Thursday, November 16, 2000 11:50 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Public synonyms
>
> 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:33:22 CST