--- In IBObjects@yahoogroups.com, "Dmitry Beloshistov" <torin@...>
wrote:

> Transaction.StartTransaction;
> //---
> with IBOQuery do
> begin
> Close; SQL.Text:=Format('GRANT %s TO %s',[RoleName,UserName]);
> Execute;
> // ^^^^ No Open! Use Execute or ExecSQL instead.
> Close;
> end;
> //--
> Transaction.Commit;
> Transaction.Close;
>

Thank you Dmitry
As soon as I used ExecSQL it worked ok, I need to readup on the
difference between Open & ExecSQL.

Regards

Jack