Re: ORACLE PRIVILEGE USE ANOTHER RESSOURCE

its not too hard, you can grant rights on objects to other users, like this....

grant select, update, .... on tablename to USERx;

that will allow access..... you could also create a public synonym which would allow you to avoid using the user name as a prefix, but you would still have to grant access to the synonym

good luck,
brent

>What privilege a user must have to use ressource of another user ?????
>I have a user DC. This user want use table of another user JP. I am
>connected on DC and for use another table, I write :
>SELECT * FROM JP.unetable ;
> *
>ORACLE say : ORA-00942: table or view does not exist
Received on Thu Aug 05 1999 - 14:56:16 CDT