Re: Insufficient Privileges

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 16 Mar 2003 08:53:57 -0800
Message-ID: <D_1da.6898$FH2.3356@fed1read02>

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
>
>

AFAIK, there is no such animal as "GRANT ALTER TABLE..." privilege. Did/do you mean
GARNT ALTER ANY TABLE to <username>?

Wouldn't it be simpler to simply login as the schema owner and issue the ALTER TABLE command from there? Received on Sun Mar 16 2003 - 10:53:57 CST