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
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. |