Re: type privileges and default privileges

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: type privileges and default privileges
Date: 2011-11-09 05:21:24
Message-ID: 4561.1320816084@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Let me put this differently. Should we either continue to hardcode the
> default privileges in the acldefault() function, or should we instead
> initialize the system catalogs with an entry in pg_default_acl as though
> ALTER DEFAULT PRIVILEGES GRANT USAGE ON TYPES TO PUBLIC; had been
> executed?

If you're proposing to replace acldefault() with a catalog lookup,
I vote no. I think that's a performance hit with little redeeming
social value.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Teodor Sigaev 2011-11-09 07:38:52 Re: ERROR: MergeAppend child's targetlist doesn't match MergeAppend
Previous Message Magnus Hagander 2011-11-09 05:06:37 Re: 9.1.2 ?