Public synonyms

From: Kristen Cameron <cameronkgd_at_inac.gc.ca>
Date: Thu, 16 Nov 2000 11:52:20 -0500
Message-Id: <10682.122269@fatcity.com>

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=20

867-669-2536

---

Received on Thu Nov 16 2000 - 10:52:20 CST