Mercurial > lada > lada-server
comparison db_schema/setup-db.sh @ 1170:74e5b9630064 pgaudit
Log parameters in statements.
This will allow later on to fetch parameters that changed and show
them to the client.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 09 Nov 2016 20:01:00 +0100 |
| parents | ea6b062e5305 |
| children | 5239306ee55e |
comparison
equal
deleted
inserted
replaced
| 1169:eefd0ca9e42f | 1170:74e5b9630064 |
|---|---|
| 83 ON ALL TABLES IN SCHEMA stammdaten, land TO $ROLE_NAME;" | 83 ON ALL TABLES IN SCHEMA stammdaten, land TO $ROLE_NAME;" |
| 84 | 84 |
| 85 echo configure audit trail | 85 echo configure audit trail |
| 86 psql $DB_CONNECT_STRING -d $DB_NAME --command \ | 86 psql $DB_CONNECT_STRING -d $DB_NAME --command \ |
| 87 "ALTER DATABASE $DB_NAME SET pgaudit.role TO '$AUDITOR_ROLE'; | 87 "ALTER DATABASE $DB_NAME SET pgaudit.role TO '$AUDITOR_ROLE'; |
| 88 ALTER DATABASE $DB_NAME SET pgaudit.log_parameter TO on; | |
| 88 GRANT UPDATE, DELETE ON | 89 GRANT UPDATE, DELETE ON |
| 89 land.probe, | 90 land.probe, |
| 90 land.kommentar_p, | 91 land.kommentar_p, |
| 91 land.ortszuordnung, | 92 land.ortszuordnung, |
| 92 land.zusatz_wert, | 93 land.zusatz_wert, |