3 # shell script TO GRANT privileges to the bacula database
7 db_name=${db_name:-@db_name@}
8 db_user=${db_user:-@db_user@}
10 sql iidbdb $* <<END-OF-DATA
11 CREATE USER ${db_user}
15 if sql -u${db_user} ${db_name} $* <<END-OF-DATA
18 GRANT ALL ON TABLE Filename TO ${db_user};
19 GRANT ALL ON TABLE Path TO ${db_user};
20 GRANT ALL ON TABLE File TO ${db_user};
21 GRANT ALL ON TABLE RestoreObject TO ${db_user};
22 GRANT ALL ON TABLE Job TO ${db_user};
23 GRANT ALL ON TABLE JobHisto TO ${db_user};
24 GRANT ALL ON TABLE Location TO ${db_user};
25 GRANT ALL ON TABLE Fileset TO ${db_user};
26 GRANT ALL ON TABLE JobMedia TO ${db_user};
27 GRANT ALL ON TABLE Media TO ${db_user};
28 GRANT ALL ON TABLE MediaType TO ${db_user};
29 GRANT ALL ON TABLE Storage TO ${db_user};
30 GRANT ALL ON TABLE Device TO ${db_user};
31 GRANT ALL ON TABLE Pool TO ${db_user};
32 GRANT ALL ON TABLE Client TO ${db_user};
33 GRANT ALL ON TABLE Log TO ${db_user};
34 GRANT ALL ON TABLE LocationLog TO ${db_user};
35 GRANT ALL ON TABLE Counters TO ${db_user};
36 GRANT ALL ON TABLE BaseFiles TO ${db_user};
37 GRANT ALL ON TABLE UnsavedFiles TO ${db_user};
38 GRANT ALL ON TABLE CDImages TO ${db_user};
39 GRANT ALL ON TABLE PathHierarchy TO ${db_user};
40 GRANT ALL ON TABLE PathVisibility TO ${db_user};
41 GRANT ALL ON TABLE Version TO ${db_user};
42 GRANT ALL ON TABLE Status TO ${db_user};
44 -- for sequences ON those tables
45 GRANT NEXT ON SEQUENCE Filename_Seq TO ${db_user};
46 GRANT NEXT ON SEQUENCE Path_Seq TO ${db_user};
47 GRANT NEXT ON SEQUENCE File_Seq TO ${db_user};
48 GRANT NEXT ON SEQUENCE RestoreObject_Seq TO ${db_user};
49 GRANT NEXT ON SEQUENCE Job_Seq TO ${db_user};
50 GRANT NEXT ON SEQUENCE JobHisto_Seq TO ${db_user};
51 GRANT NEXT ON SEQUENCE Location_Seq TO ${db_user};
52 GRANT NEXT ON SEQUENCE Fileset_Seq TO ${db_user};
53 GRANT NEXT ON SEQUENCE Jobmedia_Seq TO ${db_user};
54 GRANT NEXT ON SEQUENCE Media_Seq TO ${db_user};
55 GRANT NEXT ON SEQUENCE MediaType_Seq TO ${db_user};
56 GRANT NEXT ON SEQUENCE Storage_Seq TO ${db_user};
57 GRANT NEXT ON SEQUENCE Device_Seq TO ${db_user};
58 GRANT NEXT ON SEQUENCE Pool_Seq TO ${db_user};
59 GRANT NEXT ON SEQUENCE Client_Seq TO ${db_user};
60 GRANT NEXT ON SEQUENCE Log_Seq TO ${db_user};
61 GRANT NEXT ON SEQUENCE LocationLog_Seq TO ${db_user};
62 GRANT NEXT ON SEQUENCE BaseFiles_Seq TO ${db_user};
67 echo "Privileges for ${db_user} granted on ${db_name}."
70 echo "Error creating privileges."