Quick MySQL Question

[hukkas]

Hello

 

I'd like to create two MySQL users, one to be used by the osCommerce application, and one for the admin tool. Presumably, each one only needs a fairly limited set of permissions - e.g., the database user used by the application won't need UPDATE access to the configuration tables.

 

I guess the GRANT statements could be compiled into a script......so, anyone done such a thing?

 

(Apologies if the terminology isn't quite correct - I'm no DBA)

 

Cheers