RE: Public synonyms

From: William Rogge <William_Rogge_at_voltek.com>
Date: Thu, 16 Nov 2000 12:22:13 -0500
Message-Id: <10682.122274@fatcity.com>

Understand, SYNONYMS are nothing more than short cuts for referencing items. Instead of having to enter the table/view owner as a qualifier.  You always need to grant access to either a role or individual if the individual wants to access data in the table/view.

-----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:22:13 CST