Postgres::setUser PHP Method

setUser() public method

Adjusts a user's info
public setUser ( $username, $password, $createdb, $createuser, $expiry )
$username The username of the user to modify
$password A new password for the user
$createdb boolean Whether or not the user can create databases
$createuser boolean Whether or not the user can create other users
$expiry string Format 'YYYY-MM-DD HH:MM:SS'. '' means never expire.
    function setUser($username, $password, $createdb, $createuser, $expiry)
    {
        $enc = $this->_encryptPassword($username, $password);
        $this->fieldClean($username);
        $this->clean($enc);
        $this->clean($expiry);
        $sql = "ALTER USER \"{$username}\"";
        if ($password != '') {
            $sql .= " WITH ENCRYPTED PASSWORD '{$enc}'";
        }
        $sql .= $createdb ? ' CREATEDB' : ' NOCREATEDB';
        $sql .= $createuser ? ' CREATEUSER' : ' NOCREATEUSER';
        if ($expiry != '') {
            $sql .= " VALID UNTIL '{$expiry}'";
        } else {
            $sql .= " VALID UNTIL 'infinity'";
        }
        return $this->execute($sql);
    }
Postgres