Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Insufficient privileges for GRANT

Re: Insufficient privileges for GRANT

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 10 Sep 2007 06:26:38 +0200
Message-ID: <46e4c77f$0$26733$426a74cc@news.free.fr>

"krissco" <kris.scorup_at_gmail.com> a écrit dans le message de news: 1189385787.764989.32120_at_y42g2000hsy.googlegroups.com...
| I'm having an issue granting the REFERENCES permission to a user.
|
| User A owns the table.
| User B already has privileges to select, insert, etc. from the table.
| I want user B to be able to create a table (in their schema) that
| contains a foreign key which references user A's table.
| "A" and "B" are not the actual user names.
|
|
| --I log in as a "privileged" user
| live> conn sys
| Enter password:
| Connected.
|
| --Just for proof that this user should be able to GRANT
| live> select *
| 2 from dba_sys_privs
| 3 where grantee = 'SYS'
| 4 and privilege like '%GRANT%'
| 5
| live> /
|
| GRANTEE
| PRIVILEGE ADM
| ------------------------------
| ---------------------------------------- ---
| SYS GRANT ANY
| PRIVILEGE YES
| SYS GRANT ANY
| ROLE YES
|
|
| --The GRANT fails
| live> grant references (field_name) on A.AsTableName to B
| 2
| live> /
| grant references (field_name) on A.AsTableName to B
| *
| ERROR at line 1:
| ORA-01031: insufficient privileges
|
|
| Any thoughts? I'm running Oracle7 Server Release 7.3.4.0.0
|
| Thanks!
|
| -Kris
|

By defaullt, SYS does not have any object privilege on schema objects and so it cant' grant them.

Btw, don't use SYS for anything but maintenance purpose. Why don't you use A to grant privilege on A objects?

Regards
Michel Received on Sun Sep 09 2007 - 23:26:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US