-
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 ?
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
|