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

Re: what permission are needed to have constrainst across schemas?

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: 2000/03/15
Message-ID: <38d8e0df.16344792@netnews.worldnet.att.net>#1/1

I believe that the privilege you want is REFERENCES. For example:

        GRANT REFERENCES ON MY_TABLE TO SOMEONE_ELSE; Jonathan



jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Tue, 14 Mar 2000 18:03:12 GMT,
andreyNSPAM_at_bookexchange.net (NetComrade) wrote:

>I have given select, update, delete, doesn't work.
Received on Wed Mar 15 2000 - 00:00:00 CST

Original text of this message

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