Subject how to accessing table in another database from stored procedure
Author Yohanes Ongky Setiadji
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


[Non-text portions of this message have been removed]