We have existing database where several tables have GRANT ALL TO PUBLIC. However, when new users are added, they seem to get privilege problem until another GRANT ALL TO PUBLIC is issued. If this is truly the case (and we're not crazy) then each time a new user is added, new GRANTs will have to be executed. Is this correct? Is this intentional? Anyone know a work around?
MM ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster