3 # shell script to grant privileges to the bacula database
7 if $bindir/psql $* -f - <<END-OF-DATA
13 grant all on unsavedfiles to bacula;
14 grant all on basefiles to bacula;
15 grant all on jobmedia to bacula;
16 grant all on file to bacula;
17 grant all on job to bacula;
18 grant all on media to bacula;
19 grant all on client to bacula;
20 grant all on pool to bacula;
21 grant all on fileset to bacula;
22 grant all on path to bacula;
23 grant all on filename to bacula;
24 grant all on counters to bacula;
25 grant all on version to bacula;
27 -- for sequences on those tables
29 grant select, update on filename_filenameid_seq to bacula;
30 grant select, update on path_pathid_seq to bacula;
31 grant select, update on fileset_filesetid_seq to bacula;
32 grant select, update on pool_poolid_seq to bacula;
33 grant select, update on client_clientid_seq to bacula;
34 grant select, update on media_mediaid_seq to bacula;
35 grant select, update on job_jobid_seq to bacula;
36 grant select, update on file_fileid_seq to bacula;
37 grant select, update on jobmedia_jobmediaid_seq to bacula;
38 grant select, update on basefiles_baseid_seq to bacula;
42 echo "Privileges for bacula granted."
45 echo "Error creating privileges."