/usr/share/awl/dba/grant-minimum-permissions.sh is in libawl-php 0.56-1ubuntu1.
This file is owned by root:root, with mode 0o755.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 | #!/bin/sh
#
# Grant permissions to AWL tables for Web application and DBA users
#
# Since we don't know anything about the database connection we echo
# the SQL for our caller to pipe into the database.
#
APPUSER=${1:-"general"}
DBAUSER=${2}
cat <<EOPERMS
GRANT SELECT,INSERT,UPDATE ON
usr
, usr_setting
, roles
, role_member
, session
, tmp_password
TO ${APPUSER};
GRANT SELECT,UPDATE ON
usr_user_no_seq
, session_session_id_seq
TO ${APPUSER};
GRANT SELECT ON
supported_locales
, awl_db_revision
TO ${APPUSER};
GRANT DELETE ON
tmp_password
, role_member
TO ${APPUSER};
EOPERMS
if [ -n "${DBAUSER}" ]; then
cat <<EOPERMS
GRANT ALL ON
usr
, usr_setting
, roles
, role_member
, session
, tmp_password
, usr_user_no_seq
, session_session_id_seq
, supported_locales
, awl_db_revision
, tmp_password
, role_member
TO ${DBAUSER};
EOPERMS
fi
|