HuasoFoundries / phpPgAdmin6

     * @param int $admin    (optional) Flag to grant the admin option

     * @return \PHPPgAdmin\Database\A 0 success

     */

    public function grantRole($role, $rolename, $admin = 0)

    {

        $this->fieldClean($role);

        $this->fieldClean($rolename);

        $sql = "GRANT \"{$role}\" TO \"{$rolename}\"";

        if ($admin == 1) {

            $sql .= ' WITH ADMIN OPTION';

        }

        return $this->execute($sql);

    }

    /**

     * Revokes membership in a role

     * @param string $type     (optional) Type of revoke: RESTRICT | CASCADE

     * @return \PHPPgAdmin\Database\A 0 success

     */

    public function revokeRole($role, $rolename, $admin = 0, $type = 'RESTRICT')

    {

        $this->fieldClean($role);

        $this->fieldClean($rolename);

        $sql = 'REVOKE ';

        if ($admin == 1) {

            $sql .= 'ADMIN OPTION FOR ';

        }

        $sql .= "\"{$role}\" FROM \"{$rolename}\" {$type}";

        return $this->execute($sql);

    }

    /**

     * Removes a role