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?

link|improve this question

feedback

1 Answer

up vote 2 down vote accepted

Yes. Revoke privileges from public schema.

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

Your Answer

 
or
required, but never shown

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