From: Korry Douglas <korry.douglas@enterprisedb.com>
To: John Scalia <jayknowsunix@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Adding group role to a user
Date: Wed, 30 Sep 2015 13:50:57 -0400
Message-ID: <560C2101.7020807@enterprisedb.com> (raw)
In-Reply-To: <CABzCKRAx8z6N0hGanRKSS_Va58U6xfAevD5HmyYmEx2pxtZWrQ@mail.gmail.com>
References: <CABzCKRCmO6A+8y+dpneX6KwShmw0mFDkK4bAG+vVxnYaGz0A2Q@mail.gmail.com>
<560C1AC5.7040401@enterprisedb.com>
<CABzCKRAx8z6N0hGanRKSS_Va58U6xfAevD5HmyYmEx2pxtZWrQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
It would have been polite of me to include a reference, apologies.
Group names and user names (which are really /role/ names) are
considered to be identifiers. This page explains the quoting rules for
identifiers in PostgreSQL:
http://www.postgresql.org/docs/9.4/static/sql-syntax-lexical.html
-- Korry
> I think that was only variant I hadn't tried. Looking through the
> history I had only used a single quote around the group name, not a
> double, but that did work.
>
> Thanks,
> Jay
>
> On Wed, Sep 30, 2015 at 12:24 PM, Korry Douglas
> <korry.douglas@enterprisedb.com
> <mailto:korry.douglas@enterprisedb.com>> wrote:
>
>
> ALTER GROUP "schema-rw" ADD USER someuser.
>
>
> -- Korry
>
>
> Someone here in their infinite wisdom decided that all our
> group names would contain a "-". Thus, all the groups look
> like "schema-ro" or "schema-rw", My problem is that neither a
> "grant <group-name> to <user>;" nor a "alter group
> <group-name> add user <user>" will work properly as the
> command interpreter doesn't like the group name having a "-"
> in it.
>
> So, I'm looking for a work-around up to and including directly
> altering the pg_auth table. Any ideas?
> --
> Jay
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: korry.douglas@enterprisedb.com, jayknowsunix@gmail.com
Subject: Re: Adding group role to a user
In-Reply-To: <560C2101.7020807@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox