--- 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 ");