Take the 2-minute tour ×

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?

share|improve this question

1 Answer 1

up vote 3 down vote accepted

Yes. Revoke privileges from public schema.

share|improve this answer
Looks like revoke create on schema public from public; works. –  dar Sep 21 '09 at 12:29

Your Answer


