We have the application that uses Firebird 2.0.3 Server and accesses
to is through ODBC (Firebird driver 1.2).
When application creates stored procedures under non-SYSDBA user and
then tries to execute some of them
under restricted user, function that called execution hangs with no
result.
Also such query: UPDATE <sometable> SET BLOCK = (SELECT BLOCK FROM
<anothertable> WHERE <someUID> = 1) WHERE <someUID> = 1" hangs,
where BLOCK is binary BLOB.

Is there any solution or workaround for this?

P.S. Also this problem can be reproduced with FB 2.0.0, FB 2.0.1 and
2.0b ODBC FB driver.