Re: ORACLE PRIVILEGE USE ANOTHER RESSOURCE

Hi,

SQLPLUS Help says.

GRANT {object_priv | ALL [PRIVILEGES]} [ (column [, column] ...) ]

   [, {object_priv | ALL [PRIVILEGES]} [ (column [, column] ...) ] ] ...     ON [schema.]object
    TO {user | role | PUBLIC} [, {user | role | PUBLIC}] ...

So connect as JP and write following command:  grant select on unetable to DC;

or

 grant ALL on unetable to DC;

Reg Kai

Jérôme Perruchas <jperruchas_at_systemplus.fr> wrote in article <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 Mon Aug 09 1999 - 15:27:04 CEST