Remove Quanta cruft.

[capital-apms.git] / dba / appuser_permissions.txt

#
# This file is used by update-rscds-database to set the correct
# permissions for the application user.  In newer installations
# the application user will probably be called app_davical (and
# the administrative user will be called dba_davical) but in
# older installations the application user was called 'general'
# and the administrative user was probably 'postgres'.
#
# See the wiki topic 'Database/Users' for more discussion.
#
# This file includes lines like:
#   GRANT SELECT,...
# which define what gets granted to the following lines like:
#   ON table1, table2, sequence1, function 3, view4, ...
# no user-serviceable parts inside, all whitespace is ignored,
# your mileage should not vary :-)
#

GRANT SELECT,INSERT,UPDATE,DELETE
  ON accountbalance
  ON accountgroup
  ON accountsummary
  ON accttran
  ON activitystatus
  ON approver
  ON appuser
  ON areastatus
  ON areatype
  ON assetstatus
  ON assettype
  ON audittrail
  ON autotext
  ON bankaccount
  ON bankimportrule
  ON batch
  ON batchqueue
  ON batchtype
  ON buildingevent
  ON buildingsystem
  ON buildingsystemtype
  ON buildingtask
  ON buildingtype
  ON cashflow
  ON cashflowtype
  ON cfchangetype
  ON chartofaccount
  ON cheque
  ON client
  ON closinggroup
  ON coaconversion
  ON company
  ON consolidationlist
  ON constructiondetails
  ON contact
  ON contacttype
  ON contract
  ON creditor
  ON debtclassification
  ON directentrydetail
  ON directorship
  ON document
  ON documenttype
  ON entitycontact
  ON entitycontacttype
  ON entitylist
  ON entitylistmember
  ON entitytype
  ON financialyear
  ON fixedasset
  ON flowrule
  ON flowruletype
  ON flowstep
  ON flowsteptype
  ON flowtask
  ON flowtasktype
  ON frequencytype
  ON groundlease
  ON guarantor
  ON image
  ON imagetype
  ON inspector
  ON invoice
  ON invoiceline
  ON invoicestatus
  ON invoiceterms
  ON joblog
  ON journaldescription
  ON leasehistory
  ON leaseimage
  ON leaseimagepage
  ON leaseindex
  ON leasestatus
  ON leasetype
  ON linknode
  ON lookupcode
  ON month
  ON monthname
  ON monthstatus
  ON newaccttrans
  ON newbatch
  ON newdocument
  ON note
  ON office
  ON officecontrolaccount
  ON officesettings
  ON outgoingdescription
  ON outgoingsbasis
  ON paymentstyle
  ON periodicdetail
  ON person
  ON persondetail
  ON persondetailtype
  ON phonedetail
  ON phonetype
  ON postaldetail
  ON postaltype
  ON programlink
  ON project
  ON projectbudget
  ON projectexpensecategory
  ON projecttype
  ON property
  ON propertyoutgoing
  ON propertytitle
  ON propertyview
  ON propforecast
  ON propforecastparam
  ON propforecasttype
  ON purchaseorder
  ON region
  ON rentalspace
  ON rentcharge
  ON rentchargeline
  ON rentchargelinestatus
  ON rentchargetype
  ON rentreview
  ON rentspacehistory
  ON replcollisionlog
  ON replloadrule
  ON repllog
  ON repltrigger
  ON reviewstatus
  ON reviewtype
  ON rp
  ON scenario
  ON scenarioassumption
  ON scenarioparameter
  ON scenariostatus
  ON servicetype
  ON shareholder
  ON streetfrontage
  ON sublease
  ON supplymeter
  ON supplymeterreading
  ON tenancylease
  ON tenancyoutgoing
  ON tenant
  ON tenantcall
  ON tenantsublease
  ON topost
  ON unittype
  ON usrgroup
  ON usrgroupmember
  ON usrgroupmenu
  ON usrgroupmenuitem
  ON usrgrouprights
  ON valuation
  ON valuationtype
  ON varianceclassification
  ON variation
  ON variationflow
  ON variationtype
  ON voucher
  ON voucherline
  ON voucherstatus

# AWL tables
  ON role_member
  ON roles
  ON session
  ON tmp_password
  ON usr
  ON usr_setting

# Maintenance views
  ON debtor_maintenance
  ON creditor_maintenance

GRANT SELECT,UPDATE
  ON batch_seq
  ON audittrailid
  ON collisionid
  ON joblogno
  ON notecode
  ON personcode
  ON replid
  ON person_personcode_seq
  ON tenant_tenantcode_seq
  ON creditor_creditorcode_seq
  ON company_companycode_seq
  ON property_propertycode_seq
  ON invoice_invoiceno_seq
  ON voucher_voucherseq_seq
  ON newbatch_batchcode_seq
  ON closinggroup_closinggroup_seq

# AWL sequences
  ON usr_user_no_seq
  ON roles_role_no_seq
  ON session_session_id_seq

GRANT SELECT
  ON supported_locales
  ON yearsummary
  ON year_balance_sheet
  ON awl_db_revision
  ON _progress_field_data