Subject | how to accessing table in another database from stored procedure |
---|---|
Author | Yohanes Ongky Setiadji |
Post date | 2010-08-23T02:34:58Z |
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]
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]