basic question about user-/role concept in postgres-databases
3
votes
1
answer
147
views
I hope this question is specific enough to be allowed and not doomed as opinion-based:
I'm fairly new at administrating postgres databases. My basic approach was to create a new user / role for each real-world user. I thought it would be advantageous for use-cases, where users simultaneously access the same database. However, I realised this has some disadvantages in terms of granting access-right to future tables.
I am now suspecting that my concept (separate user-account for each real-word user ) is not the "usual way". I could imagine, that it is sufficient to have just a generic user / role, and each real-world user uses that same generic role to connect, create, read, write, modify data and tables?
Can postgres handle such a setup just fine even in the case of concurrent read/write-actions? Is this second concept (one user-account for many users) just fine and frequently applied?
Thanks in advance for your help (or for pointing out appropriate www-sources I have missed).
Asked by xof
(35 rep)
Mar 3, 2020, 11:16 AM
Last activity: Mar 3, 2020, 12:04 PM
Last activity: Mar 3, 2020, 12:04 PM