what MySQL permissions are required for mysql_real_escape_string()?

what MySQL permissions are required for mysql_real_escape_string()?

开发者_JAVA技巧

i want to create a db user with the minimum abilities specifically for using with mres()...

---

It's done on the client side, so the only permission needed is usage (since all you need is a connection, not even read permissions)...

---

EDIT, after comments of "ircmaxell":-
You will require the following permissions / privileges to be set:-

1. INSERT
2. SELECT
3. UPDATE
4. CREATE TEMPORARY TABLES

The above privileges are the minimum ones that should be provided to any user account of each & every database of MySQL.

If administrator wants to create just a basic simple account, where the user will need to view / select the records, then only the "SELECT" permission is just required. No other permissions are needed to be given (as regards to the comment of "ircmaxell").

Hope it helps.