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