Forum OpenACS Q&A: Response to two ecommerce installations using the same db

Collapse
2: Response to two ecommerce installations using the same db (response to 1)
Posted by Cynthia Kiser on 12/27/00 07:22 PM
I am a PostGres ignoramous (lurking to learn) but if this were an ACS classic site I would solve it with grants - I would give the corp database user read access on the ec_products table owned by the store database user. Then I could do selects (using corp's normal database pools) by referring to tables like STORE.EC_PRODUCTS. Does PostGres do anything like this?