Sample Header Ad - 728x90

Programmatically create a Role with Permissions within pgAdmin’s internal user management

2 votes
0 answers
22 views
I am asking about *pgAdmin* internal user management , not *Postgres* users-and-roles. For teaching a beginning database class, I am trying to procedurally configure *pgAdmin* in Server Mode, using shell scripts, *Podman*, etc. In addition to the Administrator and User roles, I want to create a Student role with restricted permissions. The setup.py feature offers a command-line interface for configuring pgAdmin. It offers commands like: - add_user - get_role 👉🏽 Is there some procedural way to define a Role with Permissions? I need a console command equivalent for the *Permissions* tab in the *pgAdmin* GUI: screenshot of Permissions tab in pgAdmin GUI I want to procedurally create a Role that effectively has some of those checkboxes unchecked.
Asked by Basil Bourque (11188 rep)
May 16, 2025, 06:07 AM
Last activity: May 17, 2025, 03:37 AM