-create user ${USER};\r
+create user bacula;\r
\r
-- for tables\r
-grant all on unsavedfiles to ${USER};\r
-grant all on basefiles to ${USER};\r
-grant all on jobmedia to ${USER};\r
-grant all on file to ${USER};\r
-grant all on job to ${USER};\r
-grant all on media to ${USER};\r
-grant all on client to ${USER};\r
-grant all on pool to ${USER};\r
-grant all on fileset to ${USER};\r
-grant all on path to ${USER};\r
-grant all on filename to ${USER};\r
-grant all on counters to ${USER};\r
-grant all on version to ${USER};\r
-grant all on cdimages to ${USER};\r
-grant all on mediatype to ${USER};\r
-grant all on storage to ${USER};\r
-grant all on device to ${USER};\r
-grant all on status to ${USER};\r
+grant all on unsavedfiles to bacula;\r
+grant all on basefiles to bacula;\r
+grant all on jobmedia to bacula;\r
+grant all on file to bacula;\r
+grant all on job to bacula;\r
+grant all on media to bacula;\r
+grant all on client to bacula;\r
+grant all on pool to bacula;\r
+grant all on fileset to bacula;\r
+grant all on path to bacula;\r
+grant all on filename to bacula;\r
+grant all on counters to bacula;\r
+grant all on version to bacula;\r
+grant all on cdimages to bacula;\r
+grant all on mediatype to bacula;\r
+grant all on storage to bacula;\r
+grant all on device to bacula;\r
+grant all on status to bacula;\r
\r
-- for sequences on those tables\r
\r
-grant select, update on filename_filenameid_seq to ${USER};\r
-grant select, update on path_pathid_seq to ${USER};\r
-grant select, update on fileset_filesetid_seq to ${USER};\r
-grant select, update on pool_poolid_seq to ${USER};\r
-grant select, update on client_clientid_seq to ${USER};\r
-grant select, update on media_mediaid_seq to ${USER};\r
-grant select, update on job_jobid_seq to ${USER};\r
-grant select, update on file_fileid_seq to ${USER};\r
-grant select, update on jobmedia_jobmediaid_seq to ${USER};\r
-grant select, update on basefiles_baseid_seq to ${USER};\r
-grant select, update on storage_storageid_seq to ${USER};\r
-grant select, update on mediatype_mediatypeid_seq to ${USER};\r
-grant select, update on device_deviceid_seq to ${USER};\r
+grant select, update on filename_filenameid_seq to bacula;\r
+grant select, update on path_pathid_seq to bacula;\r
+grant select, update on fileset_filesetid_seq to bacula;\r
+grant select, update on pool_poolid_seq to bacula;\r
+grant select, update on client_clientid_seq to bacula;\r
+grant select, update on media_mediaid_seq to bacula;\r
+grant select, update on job_jobid_seq to bacula;\r
+grant select, update on file_fileid_seq to bacula;\r
+grant select, update on jobmedia_jobmediaid_seq to bacula;\r
+grant select, update on basefiles_baseid_seq to bacula;\r
+grant select, update on storage_storageid_seq to bacula;\r
+grant select, update on mediatype_mediatypeid_seq to bacula;\r
+grant select, update on device_deviceid_seq to bacula;\r