Dear all,
I need some recommendations. My config :
- Firebird 1.5.2 SS on a linux box.
- D7 application on WinXP using IB components.

For all normal functionalities the user is logged to the DB with a
user/role that has all except administrative rights thru a
IBDatabase component. I would like to offer him the possibility to
insert "free" SQL request in a specific part of the form but in
browse mode only to avoid any error. I have defined a new role and a
new user in the DB. I have tried to defined a second connection thru
a new IBDatabase component but it seems this can not work
(message 'Project My project.exe raised exception class
EIBInterBaseError with message 'invalid transaction handle
(expecting explicit transaction start)'). After some searches it
seems that the main application handle is used for the connection
and therefore can not be shared by 2 database components.

Does anybody could give me some hints how to reach this target (2
roles used in the same time - by different components - in the same
application/form) ? In case this is not possible, i still can
evaluate the free SQL request to ensure that it does not contain
any "dangerous" verb (update, delete, insert).

Thanks for your always so good support.

Olivier