Skip to Content.
Sympa Menu

freetds - Re: [freetds] readonly access with freetds and php

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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





Archive powered by MHonArc 2.6.24.

Top of Page