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.
Anyone know how to change the database user?
Thanks a lot