Granting permissions to perform multi-database queries
Privileges which exist in a database for a particular user apply only to the tables in that database. They do not apply to tables in another database. If a SQL query spans several databases, the administrators of all databases must grant access privileges to the user in order for the query to work.