From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | David Gauthier <davegauthierpg(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: As a table owner, can I grant "grant" ? |
Date: | 2018-07-05 17:02:07 |
Message-ID: | CAKFQuwbZHOXjD-QQvZt7LNAF_VkwW3Ft33QXiY3dnxseosJMMg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Jul 5, 2018 at 9:58 AM, David Gauthier <davegauthierpg(at)gmail(dot)com>
wrote:
> Postgres 9.5.2 on linux
>
> Given that I am not superuser, but DO have createrole...
> Can I grant some other role the ability to grant access to a table I
> created ?
>
> For Example: I create a table called foo. As the creator/owner of this
> table, I seem to have the ability to grant select,insert,update,delete
> (etc...) to other roles. I would like to grant some other role the ability
> to grant access to my table.
>
>
https://www.postgresql.org/docs/10/static/sql-grant.html
WITH GRANT OPTION
Basically, yes, but only the specific permissions granted to them having
the "with grant option" attribute.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2018-07-05 17:02:18 | Re: How to watch for schema changes |
Previous Message | David Gauthier | 2018-07-05 16:58:21 | As a table owner, can I grant "grant" ? |