[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Alfresco and postgres schemas
From: Erika Knihti-Van Driessche <erika.knihti () gmail ! com>
Date: 2022-10-31 14:18:23
Message-ID: CALgXhV-pNvcw0SkJYiZKOo1E+ka=FhMf_Vf0boyRMLF0cxiJQw () mail ! gmail ! com
[Download RAW message or body]
Hi all,
Does anyone have experience on setting up Alfresco on several postgresql
schemas? I'm not familiar with Alfresco, but I have been requested to
create 4 schemas, owned by 4 users, like "user_1" owns "user_schema_1".
"user_2" owns "user_schema_2" and so on, all under one database.
Application launches well on user_schema_1, tables are created, but for
user_schema_2 it throws an error:
"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'."
Schema access was already restricted - revoke usage, revoke all. Even after
doing this, I can still list user_schema_1 tables when connected as user_2,
although I cannot query the tables (permission denied - which is normal
after revoking everything). I would rather just create 4 databases, but I
am curious if anyone has done it on schema level, if it's even possible
with ALfresco (since other schema's tables are visible).
Thanks in advance and kind regards,
Erika
[Attachment #3 (text/html)]
<div dir="ltr">Hi all,<div><br></div><div>Does anyone have experience on setting up \
Alfresco on several postgresql schemas? I'm not familiar with Alfresco, but I \
have been requested to create 4 schemas, owned by 4 users, like "user_1" \
owns "user_schema_1". "user_2" owns "user_schema_2" and \
so on, all under one database.</div><div><br></div><div>Application launches well on \
user_schema_1, tables are created, but for user_schema_2 it throws an error: \
</div><div><span style="color:rgb(36,36,36);font-family:-apple-system,BlinkMacSystemFont,"Segoe \
UI",system-ui,"Apple Color Emoji","Segoe UI \
Emoji","Segoe UI Web",sans-serif;font-size:14px">"More than one \
Alfresco schema was found when querying the database metadata.</span></div><span \
style="box-sizing:border-box;color:rgb(36,36,36);font-family:-apple-system,BlinkMacSystemFont,"Segoe \
UI",system-ui,"Apple Color Emoji","Segoe UI \
Emoji","Segoe UI Web",sans-serif;font-size:14px"><span \
style="box-sizing:border-box"> </span>Limit the database user's permissions \
or set the 'hibernate.default_schema' property in \
'custom-hibernate-dialect.properties'."</span><div><span \
style="box-sizing:border-box;color:rgb(36,36,36);font-family:-apple-system,BlinkMacSystemFont,"Segoe \
UI",system-ui,"Apple Color Emoji","Segoe UI \
Emoji","Segoe UI \
Web",sans-serif;font-size:14px"><br></span></div><div><span \
style="box-sizing:border-box;color:rgb(36,36,36);font-family:-apple-system,BlinkMacSystemFont,"Segoe \
UI",system-ui,"Apple Color Emoji","Segoe UI \
Emoji","Segoe UI Web",sans-serif;font-size:14px">Schema access was \
already restricted - revoke usage, revoke all. Even after doing this, I can still \
list user_schema_1 tables when connected as user_2, although I cannot query the \
tables (permission denied - which is normal after revoking everything). I would \
rather just create 4 databases, but I am curious if anyone has done it on schema \
level, if it's even possible with ALfresco (since other schema's tables are \
visible).</span></div><div><span \
style="box-sizing:border-box;color:rgb(36,36,36);font-family:-apple-system,BlinkMacSystemFont,"Segoe \
UI",system-ui,"Apple Color Emoji","Segoe UI \
Emoji","Segoe UI \
Web",sans-serif;font-size:14px"><br></span></div><div><span \
style="box-sizing:border-box;color:rgb(36,36,36);font-family:-apple-system,BlinkMacSystemFont,"Segoe \
UI",system-ui,"Apple Color Emoji","Segoe UI \
Emoji","Segoe UI Web",sans-serif;font-size:14px">Thanks in advance and \
kind regards,</span></div><div><span \
style="box-sizing:border-box;color:rgb(36,36,36);font-family:-apple-system,BlinkMacSystemFont,"Segoe \
UI",system-ui,"Apple Color Emoji","Segoe UI \
Emoji","Segoe UI \
Web",sans-serif;font-size:14px">Erika</span></div><div><br></div></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic