From 5d329c9510c2f54df41d87c908700c8a05ea6fd3 Mon Sep 17 00:00:00 2001 From: Dan Langille Date: Fri, 12 Dec 2003 15:45:43 +0000 Subject: [PATCH] grant select on sequences git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@868 91ce42f0-d328-0410-95d8-f526ca767f89 --- .../src/cats/grant_postgresql_privileges.in | 20 +++++++++---------- 1 file changed, 10 insertions(+), 10 deletions(-) diff --git a/bacula/src/cats/grant_postgresql_privileges.in b/bacula/src/cats/grant_postgresql_privileges.in index 21aa8858ff..606e2a72fe 100644 --- 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 -- 2.39.5