Re: Proposal for SYNONYMS - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Proposal for SYNONYMS
Date
Msg-id 20060309171536.GH4474@ns.snowman.net
Whole thread Raw
In response to Proposal for SYNONYMS  ("Jonah H. Harris" <jonah.harris@gmail.com>)
List pgsql-hackers
* Jonah H. Harris (jonah.harris@gmail.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

pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: Proposal for SYNONYMS
Next
From: Stephen Frost
Date:
Subject: Re: Proposal for SYNONYMS