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
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.