Re: grant user

From: Eve Hoellwarth <hoellwarth-e_at_gmx.at>
Date: Tue, 11 Jun 2002 19:44:22 GMT
Message-ID: <f5kcgu4joddpm7g9ikj8jo69rs98jnj47r@4ax.com>

"zeb" wrote

>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

Only the object's owner can grant privilegs on that object to another user

kind regards
Eve Received on Tue Jun 11 2002 - 14:44:22 CDT