From 7e9b373b07ae590c3eb8a72e27edaab8f93c0758 Mon Sep 17 00:00:00 2001 From: Kern Sibbald Date: Sun, 18 Apr 2010 20:26:42 +0200 Subject: [PATCH] Add RestoreObject postgresql privilege --- .../src/cats/grant_postgresql_privileges.in | 26 ++++++++++--------- 1 file changed, 14 insertions(+), 12 deletions(-) diff --git a/bacula/src/cats/grant_postgresql_privileges.in b/bacula/src/cats/grant_postgresql_privileges.in index 77ba1981a6..4ea2b71397 100644 --- a/bacula/src/cats/grant_postgresql_privileges.in +++ b/bacula/src/cats/grant_postgresql_privileges.in @@ -35,25 +35,27 @@ grant all on log to ${db_user}; grant all on jobhisto to ${db_user}; grant all on PathHierarchy to ${db_user}; grant all on PathVisibility to ${db_user}; +grant all on RestoreObject to ${db_user}; -- for sequences on those tables grant select, update on filename_filenameid_seq to ${db_user}; -grant select, update on path_pathid_seq to ${db_user}; -grant select, update on fileset_filesetid_seq to ${db_user}; -grant select, update on pool_poolid_seq to ${db_user}; -grant select, update on client_clientid_seq to ${db_user}; -grant select, update on media_mediaid_seq to ${db_user}; -grant select, update on job_jobid_seq to ${db_user}; -grant select, update on file_fileid_seq to ${db_user}; +grant select, update on path_pathid_seq to ${db_user}; +grant select, update on fileset_filesetid_seq to ${db_user}; +grant select, update on pool_poolid_seq to ${db_user}; +grant select, update on client_clientid_seq to ${db_user}; +grant select, update on media_mediaid_seq to ${db_user}; +grant select, update on job_jobid_seq to ${db_user}; +grant select, update on jobhisto_jobid_seq to ${db_user}; +grant select, update on file_fileid_seq to ${db_user}; grant select, update on jobmedia_jobmediaid_seq to ${db_user}; -grant select, update on basefiles_baseid_seq to ${db_user}; -grant select, update on storage_storageid_seq to ${db_user}; +grant select, update on basefiles_baseid_seq to ${db_user}; +grant select, update on storage_storageid_seq to ${db_user}; grant select, update on mediatype_mediatypeid_seq to ${db_user}; -grant select, update on device_deviceid_seq to ${db_user}; +grant select, update on device_deviceid_seq to ${db_user}; 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}; +grant select, update on log_logid_seq to ${db_user}; +grant select, update on restore_restoreobjectid_seq to ${db_user}; END-OF-DATA if [ $? -eq 0 ] then -- 2.39.5