/usr/lib/bareos/scripts/ddl/grants/postgresql-readonly.sql is in bareos-database-postgresql 14.2.1+20141017gitc6c5b56-3+deb8u3.
This file is owned by root:root, with mode 0o644.
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 | -- read-only access for third party applications
CREATE USER @DB_USER@ @DB_PASS@;
GRANT SELECT ON UnSavedFiles TO @DB_USER@;
GRANT SELECT ON BaseFiles TO @DB_USER@;
GRANT SELECT ON JobMedia TO @DB_USER@;
GRANT SELECT ON File TO @DB_USER@;
GRANT SELECT ON Job TO @DB_USER@;
GRANT SELECT ON Media TO @DB_USER@;
GRANT SELECT ON Client TO @DB_USER@;
GRANT SELECT ON Pool TO @DB_USER@;
GRANT SELECT ON Fileset TO @DB_USER@;
GRANT SELECT ON Path TO @DB_USER@;
GRANT SELECT ON Filename TO @DB_USER@;
GRANT SELECT ON Counters TO @DB_USER@;
GRANT SELECT ON Version TO @DB_USER@;
GRANT SELECT ON MediaType TO @DB_USER@;
GRANT SELECT ON Storage TO @DB_USER@;
GRANT SELECT ON Device TO @DB_USER@;
GRANT SELECT ON Status TO @DB_USER@;
GRANT SELECT ON Location TO @DB_USER@;
GRANT SELECT ON LocationLog TO @DB_USER@;
GRANT SELECT ON Log TO @DB_USER@;
GRANT SELECT ON JobHisto TO @DB_USER@;
GRANT SELECT ON PathHierarchy TO @DB_USER@;
GRANT SELECT ON PathVisibility TO @DB_USER@;
GRANT SELECT ON RestoreObject TO @DB_USER@;
GRANT SELECT ON Quota TO @DB_USER@;
GRANT SELECT ON NDMPLevelMap TO @DB_USER@;
GRANT SELECT ON NDMPJobEnvironment TO @DB_USER@;
GRANT SELECT ON DeviceStats TO @DB_USER@;
GRANT SELECT ON JobStats TO @DB_USER@;
GRANT SELECT ON TapeAlerts TO @DB_USER@;
|