Creating a role with read only privileges but user is allowed to change password

Поиск
Список
Период
Сортировка
От Ravi Roy
Тема Creating a role with read only privileges but user is allowed to change password
Дата
Msg-id CAFMBnF_1Gf2poehey0MRkN9T3Crix7XOrebTFOY-uXixzHCxiQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Creating a role with read only privileges but user is allowed to change password
Re: Creating a role with read only privileges but user is allowed to change password
Список pgsql-general
Дерево обсуждения
Hi Guys,

I've created a role named "MyRole" in posgresql with the following :

CREATE ROLE "MyRole" NOSUPERUSER LOGIN NOCREATEDB NOCREATEROLE NOINHERIT PASSWORD "MyPassword";

ALTER ROLE "MyRole" set default_transaction_read_only = on; 

Because I wanted this role to readonly (can not change anything in DB but only view).

But later I realized this role is not even allowed to change his password. I've tried several permutations and combinations but it does not work.

Can somebody help as how to allow this role to change his password only and everything else is read only? I'm not sure if this is possible.

Thanks.
Regards
Ravi.

В списке pgsql-general по дате отправления:

Предыдущее
От: David G Johnston
Дата:
Сообщение: Re: Partitioning such that key field of inherited tables no longer retains any selectivity
Следующее
От: Ravi Roy
Дата:
Сообщение: Re: Creating a role with read only privileges but user is allowed to change password