public inbox for [email protected]  

help / color / mirror / Atom feed

From: Andrus <[email protected]>
To: pgsql-general <[email protected]>
Subject: How to grant role to other user
Date: Sun, 1 Sep 2024 22:28:17 +0300
Message-ID: <[email protected]> (raw)

Hi!

Postgres 16 has user ingmar which is marked as superuser and has create 
role rights:

     CREATE ROLE ingmar WITH
       LOGIN
       SUPERUSER
       INHERIT
       CREATEDB
       CREATEROLE
       NOREPLICATION
       BYPASSRLS
       ENCRYPTED PASSWORD 'md5aaaaaaa790012b7aa47017f124e263d8';

     GRANT "240316_owner" TO ingmar;
     GRANT eeva_owner TO ingmar WITH ADMIN OPTION;

User ingmar creates role "ingmar.e" using

     CREATE ROLE "ingmar.e" LOGIN

and tries to grant eeva_owner role to it using

     GRANT "eeva_owner" TO "ingmar.e"

This command throws error

  ERROR: permission denied to grant role "eeva_owner"

DETAIL: Only roles with the ADMIN option on role "eeva_owner" may grant 
this role.

How user ingmar can grant role eeva_owner to user  "ingmar.e" ?

Using

PostgreSQL 16.4 (Debian 16.4-1.pgdg120+1) on x86_64-pc-linux-gnu, 
compiled by gcc (Debian 12.2.0-14) 12.2.0

Posted also in

https://stackoverflow.com/questions/78938204/how-to-grant-role-to-user

Andrus.

reply

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: [email protected]
  Cc: [email protected]
  Subject: Re: How to grant role to other user
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox