Re: ORACLE PRIVILEGE USE ANOTHER RESSOURCE

connect as your user JP via SQL+ and type the following:

    grant select on yourtablename to DC;

If I am not mistaken, this should give the DC user the privilege to select records from the other user's table. The same can be done for insert, update or delete.

Diaz Smiedts

Jérôme Perruchas wrote in message <37A94986.2CB3BCC5_at_systemplus.fr>...
>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.
>
Received on Thu Aug 05 1999 - 13:17:31 CEST