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

First I don’t know what I was thinking… I think this only change the default for the current use… not all users; I just never use this form.

alter default privileges in schema readonly grant select on tables to readonly;

> On Nov 7, 2018, at 2:08 AM, pavan95 <pavan(dot)postgresdba(at)gmail(dot)com> wrote:
>
> Rui,
>
> Thanks for responding. I'm perfectly alright with this approach. But can we
> do the same in "PUBLIC" schema??
>

Yeah; but why I think it already defaults to that; like I said before you should drop the public schema and not use it.

The other option is to revoke from the public role on the public schema.

I normally create a schema owner user that owns the objects and is only use for creating objects. Then I alter it default privileges to grant what ever access the application needs and other user role needs, etc. It’s always better to be granular if you development model supports it instead of sweeping rules.