Connect to remote database return error on select

[caspero]

Hello guys I’m facing crazy error :

SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user ‘ptdev_pms’@‘localhost’ for table ‘properties’

this error comes when I’m selecting data from table (properties) exist at remote database on another subdomain … I made sure that the connection is established correctly by using ConnectionManager::get(‘Ptpms’); which is identified in app.php … the query execution working fine but when I want to access the object by toArray() I gotting the error… and the object not readable as well… at my local it works fine … but when I upload it to server I got the error …
I noticed , at the server I have MySQL , in my local I have MariaDB … may this may cause the error ?!!

please check the attached screen

any help please ?

thanks in advance

[caspero]

I solved it … it was really silly mistake took me 2 days of search … the weird thing is, it was work locally but not on the server

I had in my PropertiesTable.php
$this->setTable(‘Ptpms.properties’);

and this was the mistake , I removed the connection prefix and it works!!
$this->setTable(‘properties’);

but the debugger wasn’t even close to the reason