Re: Small filx on the documentation of ALTER DEFAULT PRIVILEGES - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Small filx on the documentation of ALTER DEFAULT PRIVILEGES
Date
Msg-id 3688200.1713967024@sss.pgh.pa.us
Whole thread Raw
In response to Small filx on the documentation of ALTER DEFAULT PRIVILEGES  (Yugo NAGATA <nagata@sraoss.co.jp>)
List pgsql-hackers
Yugo NAGATA <nagata@sraoss.co.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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Remove unnecessary code rom be_lo_put()
Next
From: Alena Rybakina
Date:
Subject: Re: Fix parallel vacuum buffer usage reporting