Re: Confused
| From: | Martin Marques | Date: | Sun, 05 Oct 2003 16:07:50 +0000 |
| Subject: | Re: Confused | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30844@lists.php.net to get a copy of this message | ||
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 | mmarques@unl.edu.ar
Programador, Administrador, DBA | Centro de Telemática
Universidad Nacional
del Litoral
-----------------------------------------------------------------