GRANT role TO role;

I am trying to run postgraphile on neon and my current setup requires multiple roles and being able to switch to them for part of the permission handling. This looks like is not possible today. I tried

GRANT app_anonymous TO appuser;

in the sql editor but got

ERROR: permission denied to grant role "app_anonymous" I have also tried this logged in as app_anonymous

Hey @martior, welcome!

Granting a role to another role should be possible. Have you checked out this guide in our docs?

That worked great, thanks. I had made the original roles through the web interface, and it didn’t work for them.

1 Like

That worked great, thanks.

No problem! :smile:

I had made the original roles through the web interface, and it didn’t work for them.

This is good feedback. I’ll share it with the team

Are there plans to make this even simpler via the Roles page in the dashboard? Thinking a simple checkbox to make the new role readonly with some sane defaults

Are there plans to make this even simpler via the Roles page in the dashboard

Nothing is planned yet when it comes to role management via the console UI, but I shared your feedback with our Product team :smile: