Re: Small filx on the documentation of ALTER DEFAULT PRIVILEGES

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Small filx on the documentation of ALTER DEFAULT PRIVILEGES
Date: 2024-04-24 13:57:04
Message-ID: 3688200.1713967024@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp> writes:
> We can specify more than one privilege type in
> "ALTER DEFAULT PRIVILEGES GRANT/REVOKE ON SCHEMAS",
> for example,

> ALTER DEFAULT PRIVILEGES GRANT USAGE,CREATE ON SCHEMAS TO PUBLIC;

> However, the syntax described in the documentation looks to
> be allowing only one,

> GRANT { USAGE | CREATE | ALL [ PRIVILEGES ] }
> ON SCHEMAS
> TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]

> while the syntaxes for tables and sequences are described correctly.

Yup, you're right. I'll push this shortly.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alena Rybakina 2024-04-24 14:01:19 Re: Fix parallel vacuum buffer usage reporting
Previous Message Tom Lane 2024-04-24 13:25:09 Re: Remove unnecessary code rom be_lo_put()