On Thu, 24 Feb 2000, Benjamin Tehan wrote:
> i tried that also and it didnt work
>
> [admin@host3 admin]$ su postgres
> Password:
> su: incorrect password
> [admin@host3 admin]$
>
> If i su postgres from root i dont need to enter a password
>
Probably because password of postgres account is disabled! :-)
Seriousely, postgres account gets "!!" as its password in /etc/shadow, and
it only means one thing: no one can login to postgres account. This
extends to "su" from another account as well.
But of course most security checks are ignored if you are "root";
including "su" into a disabled account.
cheers,
Hossein
