> * Hale, Tyler (Tyler(dot)Hale(at)capitalone(dot)com) wrote:
>> >Thanks for the insight Stephen. Do you know if this type of functionality is only limited to sequences or all types of database objects? I am relatively new to Postgres and am trying to come up with rules/best practices for my team to use when deploying new structures on Postgres.
best practices IMHO are to include the GRANT's with the CREATE
statements. grant permissions to groups rather than specific roles,
and make the user roles members of those groups.
--
john r pierce, recycling bits in santa cruz