Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Foreign key to another schema

Status
Not open for further replies.
Leon1977

Leon1977

IS-IT--Management
Jun 27, 2001
79
0
0
BG
Is there a way I can point a foreign key to point to a column in a table within a different schema
I have the SELECT option granted. Do I need some other object priviledge
 
Sort by date Sort by votes
yes for sure you need another privilege on that column from another schema. That is 'REFERENCES' privilege. The other schema owner should grant you that privilege on that table.

Abhivyakti
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
149
SkipVought
S
Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
150
Livia8
Livia8
TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
184
carp
carp
TheLazyPig
  • Locked
  • Question
Separate 1 row value to multiple rows
Replies
4
Views
165
carp
carp
Livia8
  • Locked
  • Question
How to forcibly logout users 2
Replies
17
Views
324
carp
carp

Part and Inventory Search

Sponsor

Back
Top