Connecting Tech Pros Worldwide Forums | Help | Site Map

database problem

Member
 
Join Date: Mar 2007
Posts: 117
#1: Feb 13 '08
how to prevent users to use the specific databases. i mean i have lots of databases. so i want the particular user use the specified database only.
is it possible to have password in the database to lock.
thanx

Moderator
 
Join Date: Dec 2006
Location: Europe
Posts: 292
#2: Feb 13 '08

re: database problem


Quote:

Originally Posted by coolminded

how to prevent users to use the specific databases. i mean i have lots of databases. so i want the particular user use the specified database only.
is it possible to have password in the database to lock.
thanx

use pg_hba.conf to specify who which database can use.
Reply