[freetds] readonly access with freetds and php

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Fri Dec 22 10:13:16 EST 2006


> 
> I compiled php and freetds and it works like a charm. I would like to 
> disable all kinds of updates to tables and allow only select 
> queries with 
> php. I am not sure if this is possible.  I could create a 
> user with read 
> only access to the tables but scripts could be run under a 
> different user 
> that has more rights and open some holes.  Not sure if there 
> is a way to 
> hack freetds to disable updates deletes and drops of tables 
> but if there is 
> a way i would like to  do that. I believe iodbc has a 
> readonly option but i 
> am not using odbc. my only other option is to run apache in a 
> server that is 
> only reachable from inside. any ideas/suggestions ? thanks.
> 

I would create a read-only db user.

freddy77




More information about the FreeTDS mailing list