source: contrib/davical/dba/appuser_permissions.txt @ 3733

#
# 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 collection
  ON caldav_data
  ON calendar_item
  ON relationship
  ON locks
  ON property
  ON freebusy_ticket
  ON usr
  ON usr_setting
  ON roles
  ON role_member
  ON session
  ON tmp_password
  ON group_member
  ON principal
  ON relationship_type
  ON sync_tokens
  ON sync_changes
  ON grants
  ON dav_principal
  ON access_ticket
  ON dav_binding
  ON calendar_alarm
  ON calendar_attendee
  ON addressbook_resource
  ON addressbook_address_adr
  ON addressbook_address_tel
  ON addressbook_address_email

GRANT SELECT,UPDATE
  ON relationship_type_rt_id_seq
  ON dav_id_seq
  ON usr_user_no_seq
  ON roles_role_no_seq
  ON session_session_id_seq
  ON principal_type_principal_type_id_seq
  ON sync_tokens_sync_token_seq

GRANT SELECT,INSERT
  ON time_zone

GRANT SELECT
  ON supported_locales
  ON awl_db_revision
  ON principal_type