Home » SQL & PL/SQL » SQL & PL/SQL » Insufficent privileges? referencing
Insufficent privileges? referencing [message #37172] Tue, 22 January 2002 06:06 Go to next message
ref
Messages: 1
Registered: January 2002
Junior Member
I'm getting Insufficent privileges - message, when im
trying to create a foreign key which references a column in a table, which is in another schema.
(i also have a synonym)

what is the needed system privilege ?

any help?
Re: Insufficent privileges? referencing [message #37173 is a reply to message #37172] Tue, 22 January 2002 06:20 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi,

u need references privilliege. here is the syntax.

grant references on table_name to user_name;

hope it helps

cheers
pratap
Previous Topic: Alais tables
Next Topic: Dynamic creatig a users
Goto Forum:
  


Current Time: Mon Aug 02 11:35:54 CDT 2021