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, privacy policy and cookie policy

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