Error #1142 Mysql

Question

Today in my system I came across this situation. I feed my SELECT with this code:

"SELECT p.codigo,p.nome,p.fantasia FROM pessoas p LEFT OUTER JOIN pessoas_define pd ON pd.cod_pessoa = p.codigo WHERE pd.advogado = 'T' AND p.apagado = 0"

Which means I have the chart PESSOA and in the table PESSOAS_DEFINE define the type. For the SELECT above is working 100% however for the same SELECT by only changing the field of PESSOAS_DEFINE for "client" that stays that way:

SELECT p.codigo,p.nome,p.fantasia FROM p.pessoas LEFT OUTER JOIN pessoas_define pd ON pd.cod_pessoa = p.codigo WHERE pd.cliente = 'T'

Generates the following error:"SELECT commnand denied to user 'xxxxxxxxx@ip' for table 'pessoas'".

Answer 1

According to this post: https://stackoverflow.com/questions/10956195/mysql-error-1142-select-command-denied-to-user

Eh a permission error in people table!

SELECT code,p.name,p.fantasia FROM p people. LEFT OUTER JOIN persons_define pd ON pd.cod_pessoa = p.codigo WHERE pd.client = ’T'

Your SELECT is right?