From: | Dominique Devienne <ddevienne(at)gmail(dot)com> |
---|---|
To: | Andrus <kobruleht2(at)hot(dot)ee> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to grant role to other user |
Date: | 2024-09-03 14:49:50 |
Message-ID: | CAFCRh-9RoXXrtMMmpYAi50D028kcbd982w1xN-Ev9utMTT5bMg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Sep 3, 2024 at 4:31 PM Andrus <kobruleht2(at)hot(dot)ee> wrote:
> GRANT "eeva_owner" TO "ingmar.e"
> This command throws error
> ERROR: permission denied to grant role "eeva_owner"
Works are expected when I try it. FWIW. --DD
c:\Users\ddevienne>psql service=pau16
psql (17beta3, server 16.1)
ddevienne=> create role eeva_owner;
CREATE ROLE
ddevienne=> create role ingmar LOGIN CREATEROLE PASSWORD 'foo';
CREATE ROLE
ddevienne=> grant connect on database ddevienne to ingmar;
GRANT
ddevienne=> \q
c:\Users\ddevienne>psql "service=pau16 user=ingmar"
Password for user ingmar:
psql (17beta3, server 16.1)
ddevienne=> create role "ingmar.e" LOGIN;
CREATE ROLE
ddevienne=> grant eeva_owner to "ingmar.e";
ERROR: permission denied to grant role "eeva_owner"
DETAIL: Only roles with the ADMIN option on role "eeva_owner" may
grant this role.
ddevienne=> \q
c:\Users\ddevienne>psql service=pau16
ddevienne=> grant eeva_owner TO ingmar WITH ADMIN OPTION;
GRANT ROLE
ddevienne=> \q
c:\Users\ddevienne>psql "service=pau16 user=ingmar"
Password for user ingmar:
psql (17beta3, server 16.1)
ddevienne=> grant eeva_owner to "ingmar.e";
GRANT ROLE
ddevienne=>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2024-09-03 14:53:43 | Re: How to grant role to other user |
Previous Message | Shaheed Haque | 2024-09-03 13:01:50 | Re: Monitoring logical replication |