How to grant on all tables in pgAdmin4?

From: QA Collective <theqacollective(at)gmail(dot)com>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: How to grant on all tables in pgAdmin4?
Date: 2020-09-03 03:31:22
Message-ID: CADF5g4ewo+XGGNHWOXGMx9AY_WeOXyC+gyuc3UgTukT61iKKig@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hello,

I hope I've got the correct list for the pgAdmin4 web tool?

I just wanted to ask, how is it possible via pgAdmin4 UI to execute a
command like:

GRANT SELECT ON ALL TABLES IN SCHEMA abc TO "viewer";

When I went to use the Grant Wizard, I selected the tickbox for all tables,
but that resulted in SQL which granted select on each individual
table...which isn't great for a database you expect to grow in tables in
future. Ideally, this would grant select on all tables as per the command
above.

Then of course, there is the high chance I've missed something - given I'm
relatively new to all of this.

Andrew

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Khushboo Vashi 2020-09-03 04:12:03 Re: pgAdmin4 presents blank screen after login
Previous Message Darren Duncan 2020-09-03 02:42:20 Re: Critical bug: pgAdmin v4.25 has started ignoring my "Browser Command" which completely cripples me and makes me unable to manage my PostgreSQL database.