Subject Re: [firebird-support] how to accessing table in another database from stored procedure
Author Alexandre Benson Smith
Em 22/8/2010 23:34, Yohanes Ongky Setiadji escreveu:
> Hi all,
>
> I have 2 database.
> One to store the daily transaction (A) and another to store the security
> (B).
> When users logon, they only connected to the database A.
>
> Is there a way to connect to the database B from stored procedure in
> database A?
> I want to collect user data like username and password that saved in
> database B but
> user must not be able to connect directly to database B.
> So I want to create stored procedure in database A to do the job.
>
> Thanks,
>
> Ongky
>

In FB 2.5 yes.. take a look on the release notes for the new features of
execute statement.

see you !