Re: [GENERAL] [HACKERS] psql and security

2001-09-21 Thread Tom Lane
"Colin 't Hart" <[EMAIL PROTECTED]> writes: > Does postgres have a concept of a 'root' user? Then the password should > only be prompted when one isn't root; ie. adopt Unix semantics. Can't really do that in psql's \c, since it's establishing a whole new connection; there is no possibility for su

Re: [GENERAL] [HACKERS] psql and security

2001-09-21 Thread Colin 't Hart
Tatsuo Ishii: > As you can see, psql reconnect as any user if the password is same as > foo. Of course this is due to the careless password setting, but I > think it's better to prompt ANY TIME the user tries to switch to > another user. Comments? Does postgres have a concept of a 'root' user? T