Re: revoke default privileges on schema for role of original grantor

[Aditya Toshniwal]

Hi Alain,

Please raise a feature request here -
https://redmine.postgresql.org/projects/pgadmin4/issues/new

On Tue, Jan 4, 2022 at 10:35 PM Remund Alain 
wrote:

> Hi all
>
>
>
> We are using the current pgAdmin version 6.3 extensively and are super
> happy with it. Thanks a lot to everyone who is involved and works so hard
> on this product.
>
>
>
> Recently, we wanted to delete default privileges on a schema. (Right click
> on the schema à Properties… à Default privileges à klick on garbage bin
> icon). This produces the following SQL-statement:
>
>
>
> ALTER DEFAULT PRIVILEGES IN SCHEMA 
>
> REVOKE ALL ON TABLES FROM ;
>
>
>
> This works fine if the default privileges were granted by the currently
> logged in user. As we can see in the documentation
> https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.html ,
> if “FOR ROLE” is omitted, the current role is assumed.
>
> However, if the default privileges were granted by another user, this
> statement does not have any effect (because there are no default privileges
> to be revoked which were granted by the currently logged in user). In my
> opinion, the following statement is supposed to be generated:
>
>
>
> ALTER DEFAULT PRIVILEGES FOR ROLE  IN SCHEMA 
>
> REVOKE ALL ON TABLES FROM ;
>
>
>
>
>
> Of course we have perfectly valid workaround by just altering the
> statement as described and executing it manually. I just wanted to bring
> this up since it would be nice to be fixed.
>
>
>
> Again, tanks for all the work you guys pour into pgAdmin.
>
> Regards,
>
> Alain Remund
>


-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*

"Don't Complain about Heat, Plant a TREE"

revoke default privileges on schema for role of original grantor

[Remund Alain]

Hi all

We are using the current pgAdmin version 6.3 extensively and are super happy 
with it. Thanks a lot to everyone who is involved and works so hard on this 
product.

Recently, we wanted to delete default privileges on a schema. (Right click on 
the schema --> Properties... --> Default privileges --> klick on garbage bin 
icon). This produces the following SQL-statement:

ALTER DEFAULT PRIVILEGES IN SCHEMA 
REVOKE ALL ON TABLES FROM ;

This works fine if the default privileges were granted by the currently logged 
in user. As we can see in the documentation 
https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.html , if 
"FOR ROLE" is omitted, the current role is assumed.
However, if the default privileges were granted by another user, this statement 
does not have any effect (because there are no default privileges to be revoked 
which were granted by the currently logged in user). In my opinion, the 
following statement is supposed to be generated:

ALTER DEFAULT PRIVILEGES FOR ROLE  IN SCHEMA 
REVOKE ALL ON TABLES FROM ;


Of course we have perfectly valid workaround by just altering the statement as 
described and executing it manually. I just wanted to bring this up since it 
would be nice to be fixed.

Again, tanks for all the work you guys pour into pgAdmin.
Regards,
Alain Remund

Re: Difficulty in installing postgre14 " stack builder" using PG4 admin notes

[Dave Page]

Hi

On Tue, Jan 4, 2022 at 4:57 PM Mall, Sunita 
wrote:

> I am unable to install the admin stack builder on Postgre SQL14
>
> I was asked to follow some instructions on Pg4 admin, but I am not
> understanding  what to do.
>
> Are you able to send me clear step by step instructions to get the admin
> stack builder?
>
> I have the software-POSTgre SQL 14 downloaded.
>
> I have the SQL shell black window that opens
>
> I need this for a class in databases starting tomorrow.
>
> Can you please reply ASAP?
>
> Thanks
>
> Sunita Mall
>

StackBuilder is a component included in EDB's PostgreSQL Installers.
Download the installer for PostgreSQL 14 from
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads, run
it, and ensure the StackBuilder option is checked when you are asked what
components to install.

If you're trying to install pgAdmin (your message is a little confusing),
you can also select that on the same step of the PostgreSQL installer.

Alternatively you can download pgAdmin on it's own from
https://www.pgadmin.org/download/

-- 
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: https://www.enterprisedb.com

Difficulty in installing postgre14 " stack builder" using PG4 admin notes

[Mall, Sunita]

I am unable to install the admin stack builder on Postgre SQL14
I was asked to follow some instructions on Pg4 admin, but I am not 
understanding  what to do.
Are you able to send me clear step by step instructions to get the admin stack 
builder?
I have the software-POSTgre SQL 14 downloaded.
I have the SQL shell black window that opens
I need this for a class in databases starting tomorrow.
Can you please reply ASAP?
Thanks
Sunita Mall

Sent from Mail for Windows


[Kettering Health] 

**KH Confidentiality Notice**
This email may contain legally privileged and confidential information from 
Kettering Health intended only for the individual or entity named above as the 
intended recipient. If you are not the intended recipient, you are hereby 
notified that any review, dissemination, distribution, or copying of this 
communication is prohibited. If you received this communication in error, 
please notify us by email and promptly delete the original message.

Re: PSQL Tool shows blank screen

[Yogesh Mahajan]

Hi,

Can you please check selinux status on the operating system?.
Can you try disabling selinux try?

Thanks,
Yogesh Mahajan
EnterpriseDB


On Thu, Dec 30, 2021 at 6:23 PM Pool, H. (Herman)  wrote:

> Hi Yogesh,
>
>
>
> I have added the 4 lines to /etc/httpd/conf.d/pgadmin4.conf
>
> I have run the command “/usr/pgadmin4/bin/setup-web.sh –yes” without any
> error but the result is the same: a blank screen after clicking the “PSQL
> Tool” button.
>
>
>
>
>
> With regards,
>
>
>
> Herman
>
>
>
>
>
> *Van:* Yogesh Mahajan 
> *Verzonden:* woensdag 29 december 2021 12:39
> *Aan:* Pool, H. (Herman) 
> *CC:* pgadmin-support@lists.postgresql.org; Aditya Toshniwal <
> aditya.toshni...@enterprisedb.com>
> *Onderwerp:* Re: PSQL Tool shows blank screen
>
>
>
> 
>
> Let op, in deze e-mail verzonden door yogesh.maha...@enterprisedb.com,
> zijn één of meerdere verdachte links gevonden die uit voorzorg aangepast
> zijn, zodat deze opnieuw gecontroleerd worden bij het aanklikken. Links
> kunnen misbruikt worden om malware op uw systeem te installeren. Klik
> alleen op nog aanwezige links als de e-mail afkomstig is van een door u
> vertrouwde afzender.
>
> *Indien dit niet het geval is dient u deze e-mail direct te verwijderen.*
>
> DICTU Servicedesk
>
> 
>
> Hi Pool,
>
>
>
> This is a known issue tracked with RM 6567
> .
>
> Workaround for issues is to add lines in '/etc/httpd/pgadin4.conf' file
> given below
>
>
>
>
>
>
> *http://socket.io/>> RewriteEngine  on
> RewriteRule "/socket.io "  "/pgadmin4/socket.io/
> " *
>
>
>
>
>
> Thanks,
>
> Yogesh Mahajan
>
> EnterpriseDB
>
>
>
>
>
> On Wed, Dec 29, 2021 at 3:44 PM Aditya Toshniwal <
> aditya.toshni...@enterprisedb.com> wrote:
>
> Hi Pool,
>
>
>
> Are you able to import/export table data with the current binary path set ?
>
>
>
> On Wed, Dec 29, 2021 at 3:24 PM Pool, H. (Herman)  wrote:
>
> Hi,
>
>
>
> I have installed postgresql client (psql (PostgreSQL) 14.1) , PgAdmin 6.3
> on a CentOS server (CentOS Linux release 1.8.2003 (Core)) in server mode.
>
> I have set the binary paths to /usr/bin in Preferences => Paths => Binary
> paths , and validated the binary paths.
>
> I can make a connection to a database server, but when I use the “PSQL
> Tool” from the menu, I get a blank screen.
>
> See the attachments.
>
>
>
> There is no message in the /var/log/pgadmin/pgadmin4.log file.
>
> What do I wrong or have I forgotten something?
>
> Where can I look for a possible solution?
>
>
>
>
>
> With Regards,
>
>
>
> Herman
>
>
>
> Dit bericht kan informatie bevatten die niet voor u is bestemd. Indien u
> niet de geadresseerde bent of dit bericht abusievelijk aan u is gezonden,
> wordt u verzocht dat aan de afzender te melden en het bericht te
> verwijderen.
> De Staat aanvaardt geen aansprakelijkheid voor schade, van welke aard
> ook, die verband houdt met risico's verbonden aan het elektronisch
> verzenden van berichten.
>
> This message may contain information that is not intended for you. If you
> are not the addressee or if this message was sent to you by mistake, you
> are requested to inform the sender and delete the message.
> The State accepts no liability for damage of any kind resulting from the
> risks inherent in the electronic transmission of messages.
>
>
>
>
> --
>
> Thanks,
>
> Aditya Toshniwal
>
> pgAdmin Hacker | Software Architect | *edbpostgres.com*
> 
>
> "Don't Complain about Heat, Plant a TREE"
>
> Dit bericht kan informatie bevatten die niet voor u is bestemd. Indien u
> niet de geadresseerde bent of dit bericht abusievelijk aan u is gezonden,
> wordt u verzocht dat aan de afzender te melden en het bericht te
> verwijderen.
> De Staat aanvaardt geen aansprakelijkheid voor schade, van welke aard
> ook, die verband houdt met risico's verbonden aan het elektronisch
> verzenden van berichten.
>
> This message may contain information that is not intended for you. If you
> are not the addressee or if this message was sent to you by mistake, you
> are requested to inform the sender and delete the message.
> The State accepts no liability for damage of any kind resulting from the
> risks inherent in the electronic transmission of messages.
>