Re: insufficient privilege?

From: <czekala_at_real.pl>
Date: Thu, 29 Jul 1999 14:33:10 GMT
Message-ID: <7npon6$m6j$1@nnrp1.deja.com>

You need privilege select on user1.table1 with grant option (or make it as table owner)

Regards

Rafal (czekala_at_real.pl)

In article <7nkhti$90t$1_at_nnrp1.deja.com>, Brian Yan <by999_at_hotmail.com> wrote:
> Here is the script I ran:
>
> grant select on user1.table1 to role1;
>
> I got the following error:
> ORA-01031: insufficient privileges
>
> I ran this script in a DBA account which has been granted with DBA
role.
> I am wondering what kind of privileges is needed to grant a object
> privilege?
>
> Thank you for your help.
>
> Brian
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 29 1999 - 09:33:10 CDT