#!/bin/sh
#
# shell script TO grant privileges to the bareos database
#
db_user=${db_user:-bareos}
bindir=/usr/bin
db_name=${db_name:-bareos}
db_password=${db_password:-}
if [ "$db_password" != "" ]; then
   pass="password '$db_password'"
fi


$bindir/psql -f - -d ${db_name} $* <<END-OF-DATA

CREATE USER ${db_user} ${pass};

-- For tables
GRANT ALL ON UnSavedFiles TO ${db_user};
GRANT ALL ON BaseFiles TO ${db_user};
GRANT ALL ON JobMedia TO ${db_user};
GRANT ALL ON File TO ${db_user};
GRANT ALL ON Job TO ${db_user};
GRANT ALL ON Media TO ${db_user};
GRANT ALL ON Client TO ${db_user};
GRANT ALL ON Pool TO ${db_user};
GRANT ALL ON Fileset TO ${db_user};
GRANT ALL ON Path TO ${db_user};
GRANT ALL ON Filename TO ${db_user};
GRANT ALL ON Counters TO ${db_user};
GRANT ALL ON Version TO ${db_user};
GRANT ALL ON CdImages TO ${db_user};
GRANT ALL ON MediaType TO ${db_user};
GRANT ALL ON Storage TO ${db_user};
GRANT ALL ON Device TO ${db_user};
GRANT ALL ON Status TO ${db_user};
GRANT ALL ON Location TO ${db_user};
GRANT ALL ON LocationLog TO ${db_user};
GRANT ALL ON Log TO ${db_user};
GRANT ALL ON JobHisto TO ${db_user};
GRANT ALL ON PathHierarchy TO ${db_user};
GRANT ALL ON PathVisibility TO ${db_user};
GRANT ALL ON RestoreObject TO ${db_user};
GRANT ALL ON Quota TO ${db_user};
GRANT ALL ON NDMPLevelMap TO ${db_user};

-- For sequences ON those tables
GRANT SELECT, UPDATE ON filename_filenameid_seq TO ${db_user};
GRANT SELECT, UPDATE ON path_pathid_seq TO ${db_user};
GRANT SELECT, UPDATE ON fileset_filesetid_seq TO ${db_user};
GRANT SELECT, UPDATE ON pool_poolid_seq TO ${db_user};
GRANT SELECT, UPDATE ON client_clientid_seq TO ${db_user};
GRANT SELECT, UPDATE ON media_mediaid_seq TO ${db_user};
GRANT SELECT, UPDATE ON job_jobid_seq TO ${db_user};
GRANT SELECT, UPDATE ON file_fileid_seq TO ${db_user};
GRANT SELECT, UPDATE ON jobmedia_jobmediaid_seq TO ${db_user};
GRANT SELECT, UPDATE ON basefiles_baseid_seq TO ${db_user};
GRANT SELECT, UPDATE ON storage_storageid_seq TO ${db_user};
GRANT SELECT, UPDATE ON mediatype_mediatypeid_seq TO ${db_user};
GRANT SELECT, UPDATE ON device_deviceid_seq TO ${db_user};
GRANT SELECT, UPDATE ON location_locationid_seq TO ${db_user};
GRANT SELECT, UPDATE ON locationlog_loclogid_seq TO ${db_user};
GRANT SELECT, UPDATE ON log_logid_seq TO ${db_user};
GRANT SELECT, UPDATE ON restoreobject_restoreobjectid_seq TO ${db_user};
END-OF-DATA
if [ $? -eq 0 ]
then
   echo "Privileges for user ${db_user} granted ON database ${db_name}."
   exit 0
else
   echo "Error creating privileges."
   exit 1
fi
