2

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:

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.

Basil Bourque
  • 11,188
  • 20
  • 63
  • 96

0 Answers0