CODEWITHSUNDEEP
sql
smitha
smitha

Reputation: 9

Select command denied for user

I have read numerous other threads on this issue, but my problem is that I don't have higher access to phpmyadmin than access to tables so I cannot edit my privileges.

My sql is :

SELECT * FROM sh_shoe INNER JOIN sh_brand ON brandID.sh_shoe, brandID.sh_brand WHERE 1

the tables are 

sh_shoe, sh_brand

and my error message is :

SELECT command denied to user 'unn_w14007417'@'localhost' for table 'sh_brand'

now I can change the table to remove the join and the SELECT statement still works just without the other table that's required. I've spent a lot of time trying to figure this out and I really just don't understand what I'm missing.

edit: I should've stated, I do have access to that table. Which is why I'm confused that it isnt working.

Upvotes: 0

Views: 365

Answers (1)

tino.codes
tino.codes

Reputation: 1507

Your user unn_w14007417 has no access rights for a select statement on the sh_brand table.

Upvotes: 1

Related Questions