Re: Foreign Key Validation after Reference Table Ownership Change

[Louis Battuello <louis.battuello@xxxxxxxxxxx>]

On Mar 21, 2018, at 2:36 PM, David G. Johnston  wrote:

And altering an owner of a table to one lacking usage and create permissions on the schema is possible but unadvisible.

David J.

Exactly. The cause of my mistake was changing the REFERENCED table ownership to a role without granting usage on the schema, too. However, with the error occurring when acting as user_1, I wasn’t clear on where the privilege mismatch occurred and which role’s privilege required correction.