PG 13.11 checking in here.
psql=> grant create on schema my_schema to mwetmore;
GRANT
psql=> grant create, usage on schema my_schema to mwetmore;
GRANT
-----Original Message-----
From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Thursday, December 21, 2023 12:08 PM
To: richard coleman <rcoleman.ascentgl@gmail.com>
Cc: M Sarwar <sarwarmd02@outlook.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: [EXTERNAL] Re: Case sensitive grant statements in pg14?
richard coleman <rcoleman.ascentgl@gmail.com> writes:
> But there is no Copy/Pasting involved.
> if I open a psql prompt on my Ubuntu server.
> type:
> grant create on schema my_schema to bob;
> by hand and press return, it replies with the error messages about a
> syntax error at "bob"
All I can say is it works for me, and I can't tell from here what's different on your end.
regards, tom lane