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 -> what permission are needed to have constrainst across schemas?

what permission are needed to have constrainst across schemas?

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: 2000/03/14
Message-ID: <38ce7f08.643026847@news.earthlink.net>#1/1

I have given select, update, delete, doesn't work.

Thanx

  1 CREATE TABLE sw.manager_tourn (

  2          user_id         NUMBER(10) REFERENCES sw.users (id)
  3                                  ON DELETE CASCADE,
  4          tourn_id        NUMBER(5) REFERENCES stat.tournament (id)
  5                                  ON DELETE CASCADE,
  6          score           NUMBER(3),
  7          CONSTRAINT manager_tourn_pk PRIMARY KEY (user_id,
tourn_id)
  8                  USING INDEX TABLESPACE swind

tourn_id        NUMBER(5) REFERENCES stat.tournament (id)
                                                       *
ERROR at line 4:
ORA-01031: insufficient privileges

In case I forgot to mention:
We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes
Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email
Received on Tue Mar 14 2000 - 00:00:00 CST

Original text of this message

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