Look at changing your pg_hba.conf file If you have a line in the file like: host all all 127.0.0.1/32 trust change it to: host all all 127.0.0.1/32 md5
then run: pg_ctl reload should get you whare you want to be. Ben "Danilo Freitas da Costa" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi all!!! > > I'm using Postgres at company I work for few time. > I already tried many ways to create a security for my database but not > sucessfull. > The postgres was installed with default configuration and I had definied > "postgres" as root user. > However, someone else user I create have full access on all databases in > my server, with some limitations. > How can I configure access level to a database? How can I force every user > type your password to access the database? > > Thanks, > Danilo > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings