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