Hello
I have simple question about view database.
I have 2 database. 1 for my phprunner project let's called it " phprunner " database.
i have another one called " user " both on same server.
What i would like is do is to have views ( tables in read mode only) on my phprunner base that comes from the "user database".
example I have a table under " user " database that contains user emails,adresse etc. I need this table information on "phprunner " database.
I have create view rights on both database.. but as far as it is , I was only able to create views on the same databae: ex i can create view in User database as well as in Phprunenr databse.. What i'd like ( i dont even know if this is possible) : to have in database phprunner a view from user database. this way i can import it in my phprunne project .
any idea?
thank you.