How to grant role to other user

Andrus <kobruleht2@xxxxxx> · Sun, 1 Sep 2024 22:28:17 +0300



    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.