Re: foreign key!!!

Do ALL privilieges, include references granted by ADT to LAB on PRZSYS? (i.e., GRANT REFERENCES ON PRZSYS TO LAB)

Roman Nowak wrote:

> The problem...
>
> I have two user LAB and ADT (both have all privileges),
> and I have to tables PRZSYS (owner is ADT), ZLEC_DOWYK(owner is LAB)
>
> In sqlplus command:
>
> ALTER TABLE LAB.ZLEC_DOWYK ADD (
> CONSTRAINT ZLEC1_PRZSYS_FK3
> FOREIGN KEY (ID_PACJENTA)
> REFERENCES ADT.PRZSYS (
> IDENTYFIKATOR)
> )
> /
> return error :
>
> id_pacjenta,constraint ala foreign key (id_pacjenta) references
> adt.przsys(identyfikator),
>
> *
> ORA-00942 table or view does not exist
>
> What does this mean??? I have all privileges.
>
> Thanks for response.
> _______________________________________________________________________
> Politechnika Slaska Technical Univeristy of Gliwice
>
> student informatyki: Roman Nowak
> Home phone: +48 (32) 67-41-614
>
> E-mail: robonet_at_zeus.polsl.gliwice.pl
> roman_at_dumb.iinf.polsl.gliwice.pl
>
> WWW: http:\\dumb.iinf.polsl.gliwice.pl\~roman
> http:\\www.zeus.polsl.gliwice.pl\~robonet
> http:\\www.roman.ondraszek.ds.polsl.gliwice.pl (czasem dziala)
> _______________________________________________________________________
Received on Tue Oct 20 1998 - 22:49:13 CDT