I have setup a postgresql database with log ins as "admin" with full edits and "users" as read only. A number of "users" have been using this since for read only access.
However, I set this up using 'trust' in the pg_hba.conf file (which is not very secure)Now I need to make this database more secure, so I changed the setting to md5 but this affected all users and they were not able to connect to any databases in QGIS.
I quickly changed this back to 'trust' until I can learn what went wrong.
Can anyone advise how to change the security settings of my database in pg_hba.conf without affecting all users?
أكثر...
However, I set this up using 'trust' in the pg_hba.conf file (which is not very secure)Now I need to make this database more secure, so I changed the setting to md5 but this affected all users and they were not able to connect to any databases in QGIS.
I quickly changed this back to 'trust' until I can learn what went wrong.
Can anyone advise how to change the security settings of my database in pg_hba.conf without affecting all users?
أكثر...