Printable View
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 ?
grant select doesnt mean everyone can select the table just using the table name
you need to create a public synonym
I think you can create a public synonym for table A
if you don't want to use owner_name.table_name convention.
sorry guys I mean synonyms, my mind is not here today
Thanks alot for your help
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