Re: insufficient privilege?

From: <eric_peterson_at_maurices.inrg.com>
Date: Thu, 29 Jul 1999 14:08:29 GMT
Message-ID: <7npn8m$l51$1@nnrp1.deja.com>

Try running the grant while being logged on as USER1. Even with DBA rights, I have found that Oracle will not you to grant rights of a table to a role where that table belongs to someone else.

Tx
Eric Peterson
Programmer/Analyst DBA
Maurices Inc.

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:08:29 CDT