List:General Discussion« Previous MessageNext Message »
From:Duncan Hill Date:January 25 2007 11:10am
Subject:Re: Query Two Databases
View as plain text  
On Thursday 25 January 2007 11:08, Neil Tompkins wrote:
> The databases are on the same server, however the login details for each
> database are different.
>

A query executes with the credentials of the authentication used to set up the 
connection.  If you want to query two tables simultaneously across two 
databases, the user used to run the query will need SELECT access to both 
database.tables.
-- 
Scanned by iCritical.
Thread
Query Two DatabasesNeil Tompkins25 Jan
  • Re: Query Two DatabasesMartijn Tonies25 Jan
    • Re: Query Two DatabasesNeil Tompkins25 Jan
      • Re: Query Two DatabasesDuncan Hill25 Jan
      • Re: Query Two DatabasesMartijn Tonies25 Jan
  • Re: Query Two DatabasesNils J√ľnemann25 Jan
    • Re: Query Two DatabasesNeil Tompkins13 Feb
Re: Query Two DatabasesNeil Tompkins13 Feb
  • Re: Query Two DatabasesJohn Meyer13 Feb
  • Re: Query Two DatabasesHenrique Dallazuanna13 Feb