X-Git-Url: https://git.sur5r.net/?a=blobdiff_plain;f=bacula%2Fsrc%2Fcats%2Fgrant_mysql_privileges.in;h=bf89fe060ad3a567daad37078498bb1209bfb4c2;hb=37190d54ceff7f2b45a58a1c6241688cc5cba1c2;hp=b51561bde7b53e4178f7f1ee653fe40c955777e3;hpb=a79b6393d20c8d689a494fc380fb00dbece6439f;p=bacula%2Fbacula

diff --git a/bacula/src/cats/grant_mysql_privileges.in b/bacula/src/cats/grant_mysql_privileges.in
index b51561bde7..bf89fe060a 100644
--- a/bacula/src/cats/grant_mysql_privileges.in
+++ b/bacula/src/cats/grant_mysql_privileges.in
@@ -1,23 +1,20 @@
 #!/bin/sh
 #
-# shell script to create Bacula database(s)
+# shell script to grant privileges to the bacula database
 #
-
+USER=@db_user@
 bindir=@SQL_BINDIR@
+db_name=@db_name@
 
 if $bindir/mysql $* -u root -f <<END-OF-DATA
 use mysql
-grant all privileges on *.* to kern@localhost with grant option;
-grant all privileges on *.* to kern@"%" with grant option;
-grant all privileges on *.* to kelvin@localhost with grant option;
-grant all privileges on *.* to kelvin@"%" with grant option;
-grant all privileges on *.* to bacula@localhost with grant option;
-grant all privileges on *.* to bacula@"%" with grant option;
+grant all privileges on ${db_name}.* to ${USER}@localhost;
+grant all privileges on ${db_name}.* to ${USER}@"%";
 select * from user;
 flush privileges;
 END-OF-DATA
 then
-   echo "Privileges for kern, kelvin, and bacula granted."
+   echo "Privileges for ${USER} granted on ${db_name}."
    exit 0
 else
    echo "Error creating privileges."