Thread: security
Hi! I need to prevent user access to other user's database. By default any user can connect to any database and read its scheme at least. How to restrict this access? User should connect to database he have access only. SKiller -------------------------- Sergei Keler WebMaster of "ComSet" E-Mail: skiller@comset.net http://www.comset.net --------------------------
On 2000-01-15, sk.list@comset.net mentioned: > I need to prevent user access to other user's database. > By default any user can connect to any database and read its scheme at least. > How to restrict this access? > User should connect to database he have access only. If you are using ident "authentication" then you can do that by setting up a different mapping file for each database. See pg_hba.conf for details. If you're using password authentication you have to set up a different password file for each database. See again pg_hba.conf. -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden