| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Proposal for SYNONYMS |
| Date: | 2006-03-09 17:15:37 |
| Message-ID: | 20060309171536.GH4474@ns.snowman.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
* Jonah H. Harris (jonah(dot)harris(at)gmail(dot)com) wrote:
> In addition, SYNONYMS do participate in ACLs and support GRANT/REVOKE for
> table privileges. DROP TABLE and TRUNCATE cannot be used with synonyms.
I assume you actually mean "owner-level rights cannot be used with
synonyms".
> - Permission on a synonym does not override the permission on the referenced
> object
Need to be careful here and also make sure schema-level permissions
aren't able to be circumvented.
Sounds good to me in general though.
Thanks!
Stephen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2006-03-09 17:18:28 | Re: Proposal for SYNONYMS |
| Previous Message | Jonah H. Harris | 2006-03-09 17:11:49 | Re: Proposal for SYNONYMS |