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?

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 14:29:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.