Richard Rowell escribió: > perm_test=> revoke create on schema foo from bar; > > REVOKE > > perm_test=# revoke create on schema public from bar; > > REVOKE
You have to revoke from PUBLIC too, otherwise the user still has access via that one. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
