Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Insufficient privileges for GRANT
"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