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.
