search

io7m-com / cardant

Inventory system
https://www.io7m.com/software/cardant
ISC License
0 stars 0 forks source link

Owner role must have been granted ADMIN on worker role #98

Open io7m opened 1 month ago

io7m commented 1 month ago

Same problem as https://github.com/io7m-com/idstore/issues/153.

Detail: To change another role's password, the current user must have the CREATEROLE attribute and the ADMIN option on the role.
cardant=# GRANT cardant_read_only TO cardant_owner WITH ADMIN TRUE;
GRANT ROLE
Time: 7.732 ms
cardant=# GRANT cardant TO cardant_owner WITH ADMIN TRUE;
GRANT ROLE
Time: 8.552 ms