Re: [PATCH] pg_permissions

From: "Joel Jacobson" <joel(at)compiler(dot)org>
To: "Chapman Flack" <chap(at)anastigmatix(dot)net>, "Joe Conway" <mail(at)joeconway(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org, "Andreas Karlsson" <andreas(at)proxel(dot)se>
Subject: Re: [PATCH] pg_permissions
Date: 2021-03-11 07:00:38
Message-ID: 97e01ad4-b740-4e0e-88a7-9dd88d6b52ad@www.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

New version attached.

Changes:

* Added documentation in catalogs.sgml
* Dropped "objsubid" from pg_ownerships since columns have no owner, only tables

Do we prefer "pg_permissions" or "pg_privileges"?

I can see "privileges" occur 2325 times in the sources,
while "permissions" occur only 1097 times.

Personally, I would prefer "pg_permissions" since it seems more common in general.
"database permissions" gives 195 000 000 results on Google,
while "database privileges" only gives 46 800 000 Google results.

If we would have consistently used only "privileges" so far,
I would vote for "pg_privileges", but since there is already a mix,
I think "pg_permissions" would be nicer, it's easier to get right typing also.

/Joel

Attachment Content-Type Size
0004-pg_permissions-and-pg_ownerships.patch application/octet-stream 32.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Julien Rouhaud 2021-03-11 07:28:13 Re: Queries for PostgreSQL DDL convert
Previous Message Masahiko Sawada 2021-03-11 06:55:11 Re: Freeze the inserted tuples during CTAS?