The following Stored Procedure will list all UPDATE privileges for all users for the database, which can then be manually applied with GRANT statements.
CREATE PROCEDURE grantupdate ()
RESULT ( cSqlCmd CHARACTER(132) )
BEGIN
SQLCursor scTbl = new SQLCursor ("SELECT tblowner, tbl, grantee "
+ "FROM sysprogress.systabauth "
+ "WHERE upd = 'y'");
scTbl.open ();
scTbl.fetch ();
while (scTbl.found()) {
String sSchemaName = (String) scTbl.getValue(1, CHARACTER);
String sTblName = (String) scTbl.getValue(2, CHARACTER);
String sUser = (String) scTbl.getValue(3, CHARACTER);
sUser = "'" + sUser + "'";
String sGrantCmd = new String("GRANT UPDATE ON "
+ sSchemaName.trim() + "."
+ sTblName.trim()
+ " TO " + sUser.trim() + ";");
SQLResultSet.set (1, sGrantCmd);
SQLResultSet.insert();
scTbl.fetch();
}
scTbl.close();
SQLResultSet.set (1, "COMMIT WORK;");
SQLResultSet.insert();
END;