Odoo Server (MOVED TO GITHUB)

Different PostgreSQL users to limit access to DBs

Asked by OpenBMS JSC

I'm running different versions (e.g. 6.0 stable, 6.1dev, v.v.) of OpenERP on the same machines, and they share the same PostgreSQL instances. Currently when using OpenERP, I can connect to any OpenERP DBs, regardless whether it's created by which versions. I want to setup PostgreSQL users, so that if a OpenERP DB was created via 6.0 UI (GTK/Web), it's not accessible to someone using the 6.1dev UI. Is this possible? If yes, please provide me with some concrete examples/instructions.

Thanks a lot.

Phong.

Question information

Language:
English Edit question
Status:
Answered
For:
Odoo Server (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Vinicius Dittgen - Proge.com.br (vdittgen) said : 		#1

Hello,

You just have to setup different postgres users(with especific db
permissions only) for different openerp instances in openerp-server.conf of
each instance.

2011/6/6 Phong Nguyen-Thanh <email address hidden>

> New question #160443 on OpenERP Server:
> https://answers.launchpad.net/openobject-server/+question/160443
>
> I'm running different versions (e.g. 6.0 stable, 6.1dev, v.v.) of OpenERP
> on the same machines, and they share the same PostgreSQL instances.
> Currently when using OpenERP, I can connect to any OpenERP DBs, regardless
> whether it's created by which versions. I want to setup PostgreSQL users, so
> that if a OpenERP DB was created via 6.0 UI (GTK/Web), it's not accessible
> to someone using the 6.1dev UI. Is this possible? If yes, please provide me
> with some concrete examples/instructions.
>
> Thanks a lot.
>
> Phong.
>
> --
> You received this question notification because you are a member of
> OpenERP Framework Experts, which is an answer contact for OpenERP
> Server.
>

--

Att.:
--
Vinicius Dittgen
Proge Informática
Programas de Gestão Empresarialhttp://www.proge.com.br
Tel.:(51)3085 0096 Cel.:(51) 9193 2020
Skype: vdittgen
Canal IRC: #openerp-br

Seja um voluntário
www.centrorepensar.com.br
Centro especializado em Deficiência Intelectual, Autismo, Síndrome de
Down e Dificuldade de Aprendizagem

Can you help with this problem?

Provide an answer of your own, or ask OpenBMS JSC for more information if necessary.

To post a message you must log in.