Overslaan naar inhoud
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Alle posts Personen Badges
Labels (Bekijk alle)
odoo accounting v14 pos v15
Over dit forum
Deze vraag is gerapporteerd
1 Beantwoorden
29836 Weergaven
Avatar
gpkarthick

I have 2 user

postgresql users are 1) openerp--->databases are demo 2) arun -----> databases are sample, arun, live

arun@arun-Disktop--iam working using terminal like cd /optopenerp/server --->./openerp-server

i can view sample arun and live in localhost:8069 i can not view demo database and also postgres arun role database i can not view the tables so i try to change the postgres user as openerp how to do that can any one help me!!!!! Advance thanks

Avatar
Annuleer
Avatar
marc@k-ssuto.com
Beste antwoord

Hello,

your openERP server has 2 parameters --db_password= and --db_user= to match the correct database user.

If you want two different db-users you must either pass different parameters to your server or run 2 different openERP instances.

At the opposite, if you want to see all the database within the same server, you have to grant access to all the DB to the same user.

You can do this with the following pgsql commands :

  • ALTER DATABASE my_db OWNER TO my_user;
  • GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO my_user;
  • GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO my_user;

I you still have read errors, pass the following bash commands :

for tbl in psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" my_db ; do psql -c "alter table $tbl owner to my_user" my_db ; done

for tbl in psql -qAt -c "select sequence_name from information_schema.sequences where sequence_schema = 'public';" my_db ; do psql -c "alter table $tbl owner to my_user" my_db ; done

for tbl in psql -qAt -c "select table_name from information_schema.views where table_schema = 'public';" my_db ; do psql -c "alter table $tbl owner to my_user" my_db ; done

Hint : the complete list of server parameters are well documented. Just type

openerp-server --help

Marc.

PS: Please vote if you find this answer useful

Avatar
Annuleer