public synonym doesn't work

[elaine3839]

Ok, here is what I got:

UserA.Table1
UserB.Table1

And I created public synonym for UserA.Table1.

Now when I login as scott/tiger (or any other user w/o dba privilege), if I do

desc table1 -- I think it should work 'cause the public synonym

I got error

ORA-04043: object "UserA"."Table1" does not exist

If I login as UserA, I have no problem to desc the table.

And FYI -- The public synonym Table1 does exist in all_synonym view, owner is public, and table owner is UserA.

So what is missing here?

[marist89]

a synonym is an alias, regardless of if it is public or not.

You user must still have permission on the base object. If the user can desc usera.table1, then they should be able to reference the pubic synonym as well.

[davey23uk]

you need to grant select to b for that table

[elaine3839]

Many thanks! The grant statements to select from the base table are in my script, but for some reason, it was not executed. Now I need to look at why that was left out...

Thanks!

[santimn_sai]

hi
as per my concern public synonym means that synonym can be accessed by anybody ie that synonym only ,synonym itself is a separate object.
so other user can access that synonym but not the object referred by that synonym.for accessing that object through public synonym u have to grant privileges on that object explicitly.no grants are reqd on that synonym explicitly.beacuse that is a public synonym.

try to analyze this

[davey23uk]

why repeat what two other have just said?