From: Anderson Alves de Albuquerque <andersonaa@gmail.com>
To: pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Permission ALTER PASSWORD
Date: Wed, 8 Aug 2007 18:35:51 -0300
Message-ID: <9b3f75f0708081435p23494a95gd2ac55adf3db02b3@mail.gmail.com> (raw)
I have problem with permission, I need to use a user no SUPERUSER.
I use commands:
CREATE ROLE $USER LOGIN;
ALTER user $USER noCREATEDB NOCREATEROLE noCREATEUSER NOINHERIT;
ALTER USER $USER with password 'XX';
REVOKE create on SCHEMA public from public;
revoke all on schema PUBLIC FROM $USER;
With these commands MY user $USER don't have permission to create table and
another thing. But I need that $USER can't have permission to change your
password with:
psql -d $BD -h $HOST -U $USER
# ALTER $USER maluco with password 'YYY';
After user $USER execute this ALTER, it get change PASSWORD. Could I block
command ALTER password to user $USER?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: andersonaa@gmail.com, pgsql-general@postgresql.org
Subject: Re: Permission ALTER PASSWORD
In-Reply-To: <9b3f75f0708081435p23494a95gd2ac55adf3db02b3@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox