El Dom 05 Oct 2003 12:44, Robin Kopetzky escribió:
> 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.
You didn't give information on which database you're talking about, but any
way, I'll give you the Standard SQL way:
GRANT SELECT ON table_name TO commerce;
This always if the user already exists. :-)
--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués | [EMAIL PROTECTED]
Programador, Administrador, DBA | Centro de Telemática
Universidad Nacional
del Litoral
-----------------------------------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
