Re: REVOKE on ALTER USER, DROP USER - Mailing list pgsql-novice

From Tom Lane
Subject Re: REVOKE on ALTER USER, DROP USER
Date
Msg-id 752.1183911778@sss.pgh.pa.us
Whole thread Raw
In response to REVOKE on ALTER USER, DROP USER  (Tjibbe <tjibbe@hotmail.com>)
List pgsql-novice
Tjibbe <tjibbe@hotmail.com> writes:
> Hello, Is het possible tot REVOKE the ALTER USER command? In such a way tha=
> t users cannot change their password and username? And also cannot delete t=
> hemeself with DROP USER?

Ordinary users (those without superuser or createrole privilege) can't
do any of that except change their own password ... and I don't see a
particularly good argument for preventing them from doing that.

> Now I solve the problem in PHP, to filter de SQL query string behore sendin=
> g to postgresql as follows:

If you're allowing untrusted sources to provide chunks of SQL to be
executed directly, you've got problems far worse than this one.

            regards, tom lane

pgsql-novice by date:

Previous
From: Tjibbe
Date:
Subject: REVOKE on ALTER USER, DROP USER
Next
From: Tjibbe
Date:
Subject: Re: REVOKE on ALTER USER, DROP USER