Hi Andreas.
ACL object is missing.
All REVOKE are necessary before each establishment.
Please apply it. Or other methods?
Regards,
Hiroshi Saito
--- src/schema/pgObject.cpp.orig Tue Nov 16 02:45:46 2004
+++ src/schema/pgObject.cpp Tue Nov 16 03:01:43 2004
@@ -506,8 +506,12 @@
}
wxString grant;
if (rights.IsNull()) grant += wxT("REVOKE ALL");
- else grant += wxT("GRANT ") + rights;
-
+ else
+ {
+ grant += wxT("REVOKE ALL ON ") + grantOnObject;
+ grant += wxT(" FROM ") + user + wxT(";\n");
+ grant += wxT("GRANT ") + rights
+ }
grant += wxT(" ON ") + grantOnObject;
if (rights.IsNull()) grant += wxT(" FROM ");
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster