Can't Grant Another User's Table?

I would like to create a table which is owned by another user (for organizational purposes) yet accessible to everyone. I find that I can create the table, but I cannot refer to it in a GRANT statement.

Let's say I've created the table YOURS.TO_KEEP and I try to make it available to the public using:

GRANT SELECT
ON YOURS.TO_KEEP
TO PUBLIC I get the following error message:

ERROR at line 1:
ORA-00942: table or view does not exist

But, but, but -- the table most definitely *does* exist since I JUST did a SELECT from it. What gives? Is there a workaround? Did I miss something obvious?

Michael J. Harper
mharper_at_well.sf.ca.us Received on Wed Oct 28 1992 - 19:24:36 CET