Re: insufficient privilege?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 27 Jul 1999 15:35:58 GMT
Message-ID: <379fd1bc.8056144@newshost.us.oracle.com>

A copy of this was sent to Brian Yan <by999_at_hotmail.com> (if that email address didn't require changing) On Tue, 27 Jul 1999 15:06:32 GMT, you 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.
>

the person running the GRANT needs to be granted select WITH THE GRANT OPTION as demonstrated below:

SQL> grant select on scott.emp to connect; grant select on scott.emp to connect

                      *

ERROR at line 1:
ORA-01031: insufficient privileges

SQL> connect scott/tiger
Connected.
SQL> grant select on emp to tkyte with grant option; Grant succeeded.

SQL> connect tkyte/tkyte
Connected.
SQL> grant select on scott.emp to connect;

Grant succeeded.

>Brian
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Jul 27 1999 - 10:35:58 CDT