Anyone can give me some idea how to solve the problem... ---------- Forwarded message ---------- Date: Wed, 25 Jul 2001 14:14:38 +0800 From: Ang Sei Heng <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Help on user creation with password enable... > Hello, > > I have trying to create user (with password access) to one of the > database. Basically the user will be able to create it's own > database but unable to add other user. > > However, the password does not seems to be working. I did the > following: > > %> createuser -W -U testuser > > The message from the command seems to be ok. It prompt me for > the password. But when I try to create database via this > use, it does not prompt for password. Infact, I can even > access any database via this user. Even worst! I can simply > create/delete any tables from any database. > > I wonder did I do something wrong? I am sure that PostgreSQL 7.1.2 > should not give me such a bug right?? > > Any one out there can help me?? Am suppose to enable something > while compile PostgreSQL? I cannot let my user to access the > database system until this is solve. > > Thanks, > Sei Heng > > /* ------------------------------------------------------ > > I rather be free in Hell, then a slave in Heaven > > ------------------------------------------------------ */ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl