I have created users for which I have restricted access to SELECT from a set of tables, this works :)
But when I issue a REVOKE CREATE ON DATABASE mydb FROM myuser;
The user can still create tables...I've also issued this command for the SCHEMA and still no go.
Is this a known problem, if so how can I restrict users from creating objects in my db?
Thanks,
-Joe
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster