From 64d6d4d89a30f78ca0ca50939cc50919ca1f5975 Mon Sep 17 00:00:00 2001 From: Kern Sibbald Date: Fri, 11 Mar 2005 15:36:19 +0000 Subject: [PATCH] Fix grants for new tables in Postgresql git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@1884 91ce42f0-d328-0410-95d8-f526ca767f89 --- .../src/cats/grant_postgresql_privileges.in | 27 ++++++++++++------- 1 file changed, 17 insertions(+), 10 deletions(-) diff --git a/bacula/src/cats/grant_postgresql_privileges.in b/bacula/src/cats/grant_postgresql_privileges.in index 552232a7dd..60df1692a8 100644 --- a/bacula/src/cats/grant_postgresql_privileges.in +++ b/bacula/src/cats/grant_postgresql_privileges.in @@ -24,19 +24,26 @@ grant all on filename to ${USER}; grant all on counters to ${USER}; grant all on version to ${USER}; grant all on cdimages to ${USER}; +grant all on mediatype to ${USER}; +grant all on storage to ${USER}; +grant all on device to ${USER}; -- for sequences on those tables -grant select, update on filename_filenameid_seq to ${USER}; -grant select, update on path_pathid_seq to ${USER}; -grant select, update on fileset_filesetid_seq to ${USER}; -grant select, update on pool_poolid_seq to ${USER}; -grant select, update on client_clientid_seq to ${USER}; -grant select, update on media_mediaid_seq to ${USER}; -grant select, update on job_jobid_seq to ${USER}; -grant select, update on file_fileid_seq to ${USER}; -grant select, update on jobmedia_jobmediaid_seq to ${USER}; -grant select, update on basefiles_baseid_seq to ${USER}; +grant select, update on filename_filenameid_seq to ${USER}; +grant select, update on path_pathid_seq to ${USER}; +grant select, update on fileset_filesetid_seq to ${USER}; +grant select, update on pool_poolid_seq to ${USER}; +grant select, update on client_clientid_seq to ${USER}; +grant select, update on media_mediaid_seq to ${USER}; +grant select, update on job_jobid_seq to ${USER}; +grant select, update on file_fileid_seq to ${USER}; +grant select, update on jobmedia_jobmediaid_seq to ${USER}; +grant select, update on basefiles_baseid_seq to ${USER}; +grant select, update on storage_storageid_seq to ${USER}; +grant select, update on mediatype_mediatypeid_seq to ${USER}; +grant select, update on device_deviceid_seq to ${USER}; + END-OF-DATA then -- 2.39.5