Re: grant user

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 11 Jun 2002 19:37:41 GMT
Message-ID: <3D06517F.BFF1AE35@exesolutions.com>

zeb wrote:

> Hi,
>
> I want to have a user ( USERB) with some rights on somes tables from another
> user (USERA)
>
> I created the user: USERB
> and I did the following ( connected system/manager )
>
> SQL> grant select on USERA.TBLARTICLES to USERB;
> grant select on USERA.TBLARTICLES to USERB
> *
> ERREUR Ó la ligne 1 :
> ORA-01031: insufficient privileges
>
> What is wrong ??
>
> Thanks ...

USERA has the ability to grant on their objects to USERB ... not SYSTEM.

Daniel Morgan Received on Tue Jun 11 2002 - 14:37:41 CDT