Hi, what is the usual approach in creating users / role in a postgresql database serving as the data repository to a hosted multi-tenanted application with a large number of users.
the 2 approaches I can think of is A. The user stays and is controlled only in the application level, the application in turn connects with the postgresql database as a single user name. Any userid to be stored as part of the data is injected by the application B. Each user is also created in the postgresql database with grant or required rights to the tables. what is the usual practice ? I am unable to see any benefit in (B) above - i.e. recreating each user in the postgres database So what am i missing. A change in approach later can mean a huge rework later with warm regards Sanjay Minni +91-9900-902902 http://planage.com https://www.linkedin.com/in/sanjayminni/