remove GROUP BY on db_get_job_volume_names. REVIEW.

[bacula/bacula] / bacula / src / cats / grant_postgresql_privileges.in

diff --git a/bacula/src/cats/grant_postgresql_privileges.in b/bacula/src/cats/grant_postgresql_privileges.in
index 21aa8858ffcf5763d3258e3ffb070b46e7b8c3de..606e2a72fe132692aa01ce488600a4a8da83f263 100644 (file)
--- a/bacula/src/cats/grant_postgresql_privileges.in
+++ b/bacula/src/cats/grant_postgresql_privileges.in
@@ -24,16 +24,16 @@ grant all on version      to bacula;
 
 -- for sequences on those tables
 
-grant update on filename_filenameid_seq to bacula;
-grant update on path_pathid_seq         to bacula;
-grant update on fileset_filesetid_seq   to bacula;
-grant update on pool_poolid_seq         to bacula;
-grant update on client_clientid_seq     to bacula;
-grant update on media_mediaid_seq       to bacula;
-grant update on job_jobid_seq           to bacula;
-grant update on file_fileid_seq         to bacula;
-grant update on jobmedia_jobmediaid_seq to bacula;
-grant update on basefiles_baseid_seq    to bacula;
+grant select, update on filename_filenameid_seq to bacula;
+grant select, update on path_pathid_seq         to bacula;
+grant select, update on fileset_filesetid_seq   to bacula;
+grant select, update on pool_poolid_seq         to bacula;
+grant select, update on client_clientid_seq     to bacula;
+grant select, update on media_mediaid_seq       to bacula;
+grant select, update on job_jobid_seq           to bacula;
+grant select, update on file_fileid_seq         to bacula;
+grant select, update on jobmedia_jobmediaid_seq to bacula;
+grant select, update on basefiles_baseid_seq    to bacula;
 
 END-OF-DATA
 then