Re: ORACLE PRIVILEGE USE ANOTHER RESSOURCE

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 05 Aug 1999 20:17:45 +0800
Message-ID: <37A980E9.36A0@yahoo.com>

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.

options:

(as owner of table)

grant select on my_table to other_user;
grant update on my_table to other_user;
grant insert on my_table to other_user;
grant delete on my_table to other_user;

You probably also want to have a read on security, roles, synonyms in Server Concepts manual..

HTH --

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Aug 05 1999 - 07:17:45 CDT