freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] readonly access with freetds and php

From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] readonly access with freetds and php
Date: Fri, 22 Dec 2006 16:13:16 +0100

>
> 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

[freetds] readonly access with freetds and php, Joseph Harth, 12/22/2006
- Re: [freetds] readonly access with freetds and php, James K. Lowden, 12/22/2006
- <Possible follow-up(s)>
- Re: [freetds] readonly access with freetds and php, ZIGLIO, Frediano, VF-IT, 12/22/2006