On mandag 15 november 2004, 14:34, Kjetil Kjernsmo wrote: > GRANT SELECT, UPDATE, DELETE, INSERT ON TABLE bayes_token TO > thomasbayes; > GRANT UPDATE, SELECT, DELETE, INSERT ON TABLE bayes_vars TO > thomasbayes; GRANT SELECT, INSERT, DELETE ON TABLE bayes_seen TO > thomasbayes; GRANT SELECT, INSERT, DELETE ON TABLE bayes_expire TO > thomasbayes; GRANT SELECT ON TABLE bayes_global_vars TO thomasbayes;
FWIW, I have found during testing that this isn't sufficient, I needed at least GRANT UPDATE, SELECT, DELETE, INSERT ON bayes_vars_id_seq TO thomasbayes; ...too. This may be Pg-specific, though... Anything else...? Cheers, Kjetil -- Kjetil Kjernsmo Astrophysicist/IT Consultant/Skeptic/Ski-orienteer/Orienteer/Mountaineer [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] Homepage: http://www.kjetil.kjernsmo.net/ OpenPGP KeyID: 6A6A0BBC
