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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.