I found that grant_postgresql_privileges doesn't grant permissions on
jobhisto_jobid_seq.

Here is a patch.  It is made against 5.0.1 because the git head has changed in
an incompatible way that I don't understand.

--- src/cats/grant_postgresql_privileges.in~    Wed Feb 24 15:33:48 2010
+++ src/cats/grant_postgresql_privileges.in     Thu Apr  8 16:30:41 2010
@@ -53,6 +53,7 @@
 grant select, update on location_locationid_seq    to ${db_user};
 grant select, update on locationlog_loclogid_seq   to ${db_user};
 grant select, update on log_logid_seq             to ${db_user};
+grant select, update on jobhisto_jobid_seq        to ${db_user};
 END-OF-DATA
 if [ $? -eq 0 ]
 then

__Martin

------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel

Reply via email to