2 # This file is used by update-rscds-database to set the correct
3 # permissions for the application user. In newer installations
4 # the application user will probably be called app_davical (and
5 # the administrative user will be called dba_davical) but in
6 # older installations the application user was called 'general'
7 # and the administrative user was probably 'postgres'.
9 # See the wiki topic 'Database/Users' for more discussion.
11 # This file includes lines like:
13 # which define what gets granted to the following lines like:
14 # ON table1, table2, sequence1, function 3, view4, ...
15 # no user-serviceable parts inside, all whitespace is ignored,
16 # your mileage should not vary :-)
19 GRANT SELECT,INSERT,UPDATE,DELETE
53 ON constructiondetails
104 ON officecontrolaccount
106 ON outgoingdescription
120 ON projectexpensecategory
134 ON rentchargelinestatus
146 ON scenarioassumption
154 ON supplymeterreading
169 ON varianceclassification
186 ON debtor_maintenance
187 ON creditor_maintenance
197 ON person_personcode_seq
198 ON tenant_tenantcode_seq
199 ON creditor_creditorcode_seq
200 ON company_companycode_seq
201 ON property_propertycode_seq
202 ON invoice_invoiceno_seq
203 ON voucher_voucherseq_seq
204 ON newbatch_batchcode_seq
205 ON closinggroup_closinggroup_seq
210 ON session_session_id_seq
215 ON year_balance_sheet
217 ON _progress_field_data