From: | Ravi Roy <ravi(dot)aroy(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Ravi Roy <ravi(dot)aroy(at)gmail(dot)com> |
Subject: | Re: Creating a role with read only privileges but user is allowed to change password |
Date: | 2014-05-11 14:30:12 |
Message-ID: | CAFMBnF9G7zXK8x-GYVhcyxFr5=4VUqv9uVMMV6rzf3N_b-JZ_g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm sorry, i forgot to mention my environemnt :
Postgresql version 9.1 on Windows 7 (64 bit) and Debian Linux 6.x (64 bit)
Thanks!
Regards
Ravi.
On Sun, May 11, 2014 at 7:47 PM, Ravi Roy <ravi(dot)aroy(at)gmail(dot)com> wrote:
> 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.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ravi Roy | 2014-05-11 15:36:27 | Re: Creating a role with read only privileges but user is allowed to change password |
Previous Message | Ravi Roy | 2014-05-11 14:17:22 | Creating a role with read only privileges but user is allowed to change password |