On Wed, Jun 29, 2011 at 8:53 PM, David Fetter <da...@fetter.org> wrote: > How about this? > > PostgreSQL grants some types of objects some default privileges to > PUBLIC. Tables, columns, schemas and tablespaces grant no privileges > to PUBLIC by default. For other types, the default privileges granted > to PUBLIC are as follows: CONNECT and CREATE TEMP TABLE for databases; > EXECUTE privilege for functions; and USAGE privilege for languages. > The object owner can, of course, REVOKE both default and expressly > granted privileges.
That looks pretty good to me. I'd probably say "grants default privileges on some types of objects" rather than "grants some types of objects default privileges", but YMMV. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers