| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: viiews across schemas?
User schemaY doesn't have rights to SELECT from schemaX.tableX...
As user X
GRANT SELECT ON schemaX.tableX TO schemaY;
Then it will work...
Or the lazy DBA method... :-(
GRANT SELECT ANY TABLE TO schemaY;
Paul in VT Received on Tue Oct 12 1999 - 14:06:26 CDT
 |
 |