I assume you're using MySQL since L.A.M.P seems very popular. The following command should work anyway: GRANT permission ON tablename TO accountname@hostname IDENTIFIED BY password You can list as many permission as needed, separated by commas. cheers, feng ----- Original Message ----- From: "Robin Kopetzky" <sparkyk@blackmesa-isp.net> To: "PHP DB Group" <php-db@lists.php.net> Sent: Monday, October 06, 2003 1:44 AM Subject: Confused > I need to setup a user, 'commerce' with a password, that can be accessed > from any web server in our farm 'blackmesa-isp.net'. What "GRANT" statement > do I need to make this work? I've tried a bunch of the examples in the > manual and can't get it right. Specifically, I need the user to CONNECT, > SELECT, INSERT, UPDATE, DELETE and that's all for privileges. > > Any help is appreciated. > > Robin 'Sparky' Kopetzky > Black Mesa Computers/Internet Service > Grants, NM 87020 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
