Using postgresql 8.3, I've created a read only user like this:

create role reportuser with login password 'secret';

and then granted select to all the tables this user needs to access.

but I see this user can create table x (... and insert/update/delete/drop the table.

Is there a way to remove create table permissions for this user on this database?

1 Answer 1


Yes. Revoke privileges from public schema.

  • 1
    Looks like revoke create on schema public from public; works.
    – dar
    Sep 21, 2009 at 12:29

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .