| From: | Louis Battuello <louis(dot)battuello(at)etasseo(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Foreign Key Validation after Reference Table Ownership Change |
| Date: | 2018-03-21 18:56:34 |
| Message-ID: | DA4C8A9E-C48D-423E-A967-C9FDEFCE6C8D@etasseo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2018-03-21 19:01:26 | Re: Postgresql 10.3 , query never completes if LIMIT clause is specified and paralle processing is on |
| Previous Message | David G. Johnston | 2018-03-21 18:36:51 | Foreign Key Validation after Reference Table Ownership Change |