Can I create primary key, foreign key cross schema?

[mzahid]

Thank you for quick response. I know how to grant references to user at column level to another user.

I want to find out is if there is any or such privileges that can be granted at schema level that would allow reference any tables in the database.


This is just an hypothetical example: GRANT REFERENCES TO USER ABC;

Have anyone experienced this scenario in there environemnt?