Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[2]: What Sort of Privilege?
Mladen,
Are you caught in the exception handler???
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Gogala, Mladen [mailto:Mladen.Gogala_at_aetn.com]
Sent: Monday, August 23, 2004 6:00 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: Re[2]: What Sort of Privilege?
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]=20
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=20
email. To join, visit
http://five.pairlist.net/mailman/listinfo/oracle-article,=20
or send email to Oracle-article-request_at_gennick.com and=20
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=3D20 !!!
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=3D20
HA> -----Original Message----- HA> From: oracle-l-bounce_at_freelists.org=20 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=20 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=20 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=20 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=20 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=20 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
----------------------------------------------------------------
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
![]() |
![]() |