I installed an Alfresco 5.2 on Linux connected to a Postgres database installed on another server. 2 users have been created for the database: dba_gedmut_alfresco: total rights to the alfresco scheme (CREATE / USAGE) usr_gedmut_alfresco: classic rights (USE)
At the first launch, I use the user dba_gedmut_alfresco on alfresco-global.properties so that it creates the structure of the schema with the tables and sequences. Alfresco starts, everything is fine.
Now I have to switch to the user usr_gedmut_alfresco so that he can use the schema without other permissions. So i change in alfresco-global.properties.
Alfresco crashes at startup: Caused by: org.alfresco.error.AlfrescoRuntimeException: 05260000 More than one Alfresco schema was found when querying the database metadata. Limit the database user's permissions or set the 'hibernate.default_schema' property in 'custom-hibernate-dialect.properties'.
No matter how much I search the net for a solution, no one says how to change the database user.
FYI, I deleted all SOLR indexes before relaunching but it didn't change anything, same error.
Contrary to what is written in the link page, it is not part of an export / import. The base is the same and has 2 known users at Postgres level. But only dba_gedmut_alfresco works. It was he who initialized the base. When I change in alfresco-global.properties the user dba_gedmut_alfresco by usr_gedmut_alfresco, I get this error as if this user was looking for another scheme. Ah yes, for information, the whole structure, tables, sequences, are in lower case.