Re: Proposal for SYNONYMS

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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

> - 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.



In response to

Browse pgsql-hackers by date

  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