From: | Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | ALTER ROLES - questions |
Date: | 2005-08-15 09:46:02 |
Message-ID: | 4300645A.6090906@kaltenbrunner.cc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi!
I played around with roles a bit today and noticed some minor things:
ALTER ROLE seems to support ALTER ROLE <name> ROLE <name> - but that
form is not mentioned in the docs:
playground=# CREATE ROLE myrole;
CREATE ROLE
playground=# CREATE ROLE myrole2;
CREATE ROLE
playground=# ALTER ROLE myrole ROLE myrole2;
ALTER ROLE
ALTER ROLE <name> IN ROLE <name> (undocumented but seems logical to try
because CREATE ROLE supports that) seems to result in the following a
bit cryptic error message:
playground=# CREATE ROLE myrole;
CREATE ROLE
playground=# CREATE ROLE myrole2;
CREATE ROLE
playground=# ALTER ROLE myrole IN ROLE myrole2;
ERROR: option "addroleto" not recognized
I understand that adding/removing role membership can be done by the
means of GRANT/REVOKE but at least improving the error message(or
stopping the parser from accepting that syntax) a bit would be nice :-)
Stefan
From | Date | Subject | |
---|---|---|---|
Next Message | ohp | 2005-08-15 12:22:21 | ALTER INDEX OWNER TO |
Previous Message | David Fetter | 2005-08-15 04:25:27 | Re: SPARQL |