HuasoFoundries / phpPgAdmin6

     *

     * @return int 0 if operation was successful

     */

    public function changePassword($rolename, $password)

    {

        $enc = $this->_encryptPassword($rolename, $password);

        $this->fieldClean($rolename);

        $this->clean($enc);

        $sql = "ALTER ROLE \"{$rolename}\" WITH ENCRYPTED PASSWORD '{$enc}'";

        return $this->execute($sql);

    }

    /**

     * Adds a group member.

     *

     * @return int 0 if operation was successful

     */

    public function changePassword($username, $password)

    {

        $enc = $this->_encryptPassword($username, $password);

        $this->fieldClean($username);

        $this->clean($enc);

        $sql = "ALTER USER \"{$username}\" WITH ENCRYPTED PASSWORD '{$enc}'";

        return $this->execute($sql);

    }

    // View functions