Creating a database as an other user and giving grants doesn't seem to work for Ingres.

[bacula/bacula] / bacula / src / cats / make_ingres_tables.in

diff --git a/bacula/src/cats/make_ingres_tables.in b/bacula/src/cats/make_ingres_tables.in
index caeeaffddee883137ae5d5d29f44ed07e574e032..43f68d922454e71abbfacc9e7520ee4dbb66595f 100755 (executable)
--- a/bacula/src/cats/make_ingres_tables.in
+++ b/bacula/src/cats/make_ingres_tables.in
@@ -5,8 +5,9 @@
 bindir=@SQL_BINDIR@
 PATH="$bindir:$PATH"
 db_name=${db_name:-@db_name@}
+db_user=${db_user:-@db_user@}
 
-sql $* ${db_name} <<END-OF-DATA
+sql -u${db_user} $* ${db_name} <<END-OF-DATA
 
 SET AUTOCOMMIT ON\g