Privilege issues

[mike73]

I have a table name A and owned ny JOHN_DO, this table is granted to public. Another user named KATHY logged into the database and do a SELECT statement from table A. Here is the problem. KATHY have do this statement

SELECT * from JOHN_DO.A

I thought KAthy doesn't have to have JOHN_DO in front of the A table since JOHN_DO already granted table A to public. Any way, I want to be able to query A table by typing

SELECT * FROM A

how do I do that ?

[pando]

grant select doesnt mean everyone can select the table just using the table name

you need to create a public synonym

[NDT]

I think you can create a public synonym for table A
if you don't want to use owner_name.table_name convention.

[mike73]

sorry guys I mean synonyms, my mind is not here today

Thanks alot for your help

[marist89]

Say again?

1. john creates the table
2. john grants select to public
3. john or system creates a public synonym
create public synonym tablea for john.tablea
4. mary can now select * from tablea