I have a web app that uses a PosgreSQL database.
To use the database I use the following command:
sudo -u postgres psql
I think, this is very basic, so I'm looking for something like:
- not all users even if the use sudo can access PostgreSQL (user with limited sudo)
- users that have read only access(not referring to database type users) but OS users regaring what they can do with the files