You must create an account for users on each database or use default access to the destination database (such as through a guest account). See Drill Across and Linked Partitions.