MySQL permissions

[WoZZeR]

Hi there

I'm finding MySql permissions somewhat less than clear. What permissions does the MySql user need to get the relevant data? So far the only MySql commands on the php page are SELECT, SELECT DISTINCT, FROM, WHERE, AND, LIKE, ORDER BY and DESC

Cheers

 

[tom_e]

SELECT and possibly EXECUTE if you're running any queries from stored procedures.

 

[Deleted member 77746]

What permissions does the MySql user need to get the relevant data?

SELECT and possibly EXECUTE ^^

 

[WoZZeR]

Brilliant. I shall try this later and see if it trips up.

Thank you very much.