Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[2]: What Sort of Privilege?

RE: Re[2]: What Sort of Privilege?

From: Gogala, Mladen <Mladen.Gogala_at_aetn.com>
Date: Mon, 23 Aug 2004 18:00:03 -0400
Message-ID: <30462D80AA52E74698512ADCC4F7EAA3122396A0@EXCHANGE>


Or, you can use the same references in a different fashion as in: BEGIN
UPDATE RESUME;
SELECT * FROM MARKET_OPPORTUNITY;
SUBMIT REFERENCES TO PROSPECTIVE EMPLOYER; EXCEPTION
WHEN NO_DATA_FOUND THEN WHINE;
END;
--

Mladen Gogala
A & E TV Network
Ext. 1216

-----Original Message-----

From: Jonathan Gennick [mailto:jonathan_at_gennick.com] Sent: Monday, August 23, 2004 5:49 PM
To: Hamid Alavi
Subject: Re[2]: What Sort of Privilege?

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_at_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 HA> reference 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. 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 put 
HA> '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 put 
HA> '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 put 
HA> '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

-----------------------------------------------------------------
----------------------------------------------------------------
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:55:43 CDT

Original text of this message

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