[Firebird-devel] Cannot use stored procedures in FireBird Server under restricted user.

[dandreikin <ad...@ra...>]

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 restricted (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.
-- 
View this message in context: http://www.nabble.com/Cannot-use-stored-procedures-in-FireBird-Server-under-restricted-user.-tp15728892p15728892.html
Sent from the firebird-devel mailing list archive at Nabble.com.