-
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
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|