[Tickets #7490] Re: upgrade from 1.0.1 to 1.1.3 fails with pgsql error

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/7490
------------------------------------------------------------------------------
  Ticket             | 7490
  Updated By         | chris at vandenberghe.org
  Summary            | upgrade from 1.0.1 to 1.1.3 fails with pgsql error
  Queue              | Horde Groupware
  Version            | 1.1.3
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


chris at vandenberghe.org (2008-10-20 00:41) wrote:

Small correction/clarification:

> The horde db user is the owner of the horde schema (and has it a
> first schema in the search path), has select rights on public.users
> and no rights on any other schema/table.

The horde user has
- full rights on every table in the horde schema (i.e., on all horde  
tables as well as the right to create new tables under this schema)
- not only select (as stated before) rights but also alter/insert  
rights on the users table in order to be able to create/amend users
- no other rights

I believe the schema setup should be transparent for horde as long as  
the public schema is never mentioned explicitly.