Re: How to revoke "Create Privilege" from a readonly user in postgres?

On 5/11/18 2:12 μ.μ., pavan95 wrote:
> Hi,
>
> I want to know if there is anyway to disallow a user from creating his own
> tables.
> He should be only provided with the "SELECT" access apart from that no other
> access should be available with him.
>
> I have created a user "readonly" with no other privilege other select on
> database "abc". But when I tried to connect as "readonly" he is given with
> "SELECT" privilege but the problem here is he was also be able to create his
> own tables in the database.

Check out privileges you have given to PUBLIC. Those hold still for all future users.

>
> How this can be stopped? Looking forward to hear from you.
>
> Regards,
> Pavan
>
>
>
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
>

--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt