Re: ORACLE PRIVILEGE USE ANOTHER RESSOURCE

Jérôme Perruchas wrote:
>
> Hi,
>
> 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
> But there are not mistake in the name of the table....
> When DC has DBA privilege, Oracle doesn't say any error. But I don't
> want grant DBA privilege at DC but just the privilege for use another
> table. Do you know what privilege is-it ?????
>
> Thanks.

Try this:
connect as jp, then
SQL> grant select on unetable to dc;

cheers,
Juhan Received on Thu Aug 05 1999 - 06:55:05 CDT