On Jan 9, 2008, at 1:39 , Naz Gassiep wrote:
In a PHP project I have several functions that I use for DB operations. I only want to allow one of them to write, all the others are for reading only.
(Using DB level perms are out, as this is the function usage I'm trying to control, not the connections).
Um, why are DB-level permissions out? It seems like a natural fit: your writer connects as one role while the readers connect as another. Only grant SELECT access to the readers.
Michael Glaesemann grzm seespotcode net ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
