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

Re: Insufficient Privileges

From: DA Morgan <damorgan_at_exxesolutions.com>
Date: Sun, 16 Mar 2003 12:53:35 -0800
Message-ID: <3E74E44F.19442981@exxesolutions.com>


Wayne Hinch wrote:

> Hi,
>
> I am having problems creating a constraint between to tables in different
> schema's. The alter table command with the one constraint is below
> everything seems ok but i get error code ORA01031 against the stock table. I
> have granted the ALTER TABLE PRIVILEGE to the user i am logged in as but it
> still will not work.
>
> ALTER TABLE "DOTCOM"."SUB_LIST"
> ADD (
> CONSTRAINT "SUB_LIST_STOCK" FOREIGN KEY("TPN1") REFERENCES
> "SC"."STOCK"("TPN"));
>
> CONSTRAINT "SUB_LIST_STOCK" FOREIGN KEY("TPN1") REFERENCES
> "SC"."STOCK"("TPN"))
> *
> ERROR at line 3:
> ORA-01031: insufficient privileges
>
> Any help will be much appricated.
>
> Wayne

GRANT REFERENCES ON <table_name> TO <schema_name>;

Daneil Morgan Received on Sun Mar 16 2003 - 14:53:35 CST

Original text of this message

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