Permission ALTER PASSWORD
| От | Anderson Alves de Albuquerque |
|---|---|
| Тема | Permission ALTER PASSWORD |
| Дата | |
| Msg-id | 9b3f75f0708081435p23494a95gd2ac55adf3db02b3@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: [GENERAL] Permission ALTER PASSWORD
|
| Список | pgsql-admin |
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?
В списке pgsql-admin по дате отправления: