Re[2]: What Sort of Privilege?

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Mon, 23 Aug 2004 17:49:20 -0400
Message-ID: <37468006768.20040823174920@gennick.com>

Hello Hamid,

There is a privilige called REFERENCES, as in:

GRANT REFERENCES ON some_table TO some_user;

Best regards,

Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com

Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://five.pairlist.net/mailman/listinfo/oracle-article, or send email to Oracle-article-request_at_gennick.com and include the word "subscribe" in either the subject or body.

Monday, August 23, 2004, 5:55:20 PM, Hamid Alavi (hamid.alavi_at_quovadx.com) wrote: HA> what do you mean? references=20 !!!

HA> -----Original Message-----
HA> From: Jackie Brock [mailto:jbrock_at_energyvelocity.com]
HA> Sent: Monday, August 23, 2004 2:42 PM
HA> To: oracle-l_at_freelists.org
HA> Subject: RE: What Sort of Privilege?

HA> references=20

HA> -----Original Message-----
HA> From: oracle-l-bounce_at_freelists.org
HA> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hamid Alavi
HA> Sent: Monday, August 23, 2004 3:46 PM
HA> To: 'Oracle-L (E-mail)
HA> Subject: What Sort of Privilege?

HA> All,

HA> what kind of privilege new for creating a FK constraint which reference HA> table belongs to another schema.

HA> ALTER TABLE PAM.table1
HA>  ADD CONSTRAINT FKCONS1
HA>  FOREIGN KEY (ID)
HA>  REFERENCES schema1.table2 (ID2);

HA> I have grant select,insert,update,delete for table2 BUT still I get

HA> insufficient privilege.
HA> any idea?

HA> Hamid Alavi

HA> Office : 818-737-0526
HA> Cell phone : 818-416-5095

HA> ----------------------------------------------------------------
HA> Please see the official ORACLE-L FAQ: http://www.orafaq.com
HA> ----------------------------------------------------------------
HA> To unsubscribe send email to:  oracle-l-request_at_freelists.org
HA> put 'unsubscribe' in the subject line.
HA> --
HA> Archives are at http://www.freelists.org/archives/oracle-l/
HA> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
HA> -----------------------------------------------------------------
HA> ----------------------------------------------------------------
HA> Please see the official ORACLE-L FAQ: http://www.orafaq.com
HA> ----------------------------------------------------------------
HA> To unsubscribe send email to:  oracle-l-request_at_freelists.org
HA> put 'unsubscribe' in the subject line.
HA> --
HA> Archives are at http://www.freelists.org/archives/oracle-l/
HA> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
HA> -----------------------------------------------------------------
HA> ----------------------------------------------------------------
HA> Please see the official ORACLE-L FAQ: http://www.orafaq.com
HA> ----------------------------------------------------------------
HA> To unsubscribe send email to:  oracle-l-request_at_freelists.org
HA> put 'unsubscribe' in the subject line.
HA> --
HA> Archives are at http://www.freelists.org/archives/oracle-l/

HA> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

HA> -----------------------------------------------------------------



----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Mon Aug 23 2004 - 16:45:44 CDT