PHP-4.2.3 patch to allow restriction of database access

Поиск
Список
Период
Сортировка
От Jim Mercer
Тема PHP-4.2.3 patch to allow restriction of database access
Дата
Msg-id 20020926185445.GA39505@reptiles.org
обсуждение исходный текст
Список pgsql-general
the patch is at:
ftp://ftp.reptiles.org/pub/php/php-pgsql.patch

this patch adds the config variable pgsql.allowed_dblist

by default it has no value, meaning all databases are accessible

it can contain a colon delimited list of databases that are accessible.

if the database accessed is not in the list, and the list is not null,
then an error is returned as if the database did not exist

this patch is relative to php-4.2.3

this function would be very useful to apache/virtual hosting.

i have tested with the following in my apache httpd.conf:

<Directory /home/www/htdocs/jim>
    php_admin_value pgsql.allowed_dblist    "jim:billing"
</Directory>

although it can be accomplished by other means, setting the variable to a
value of ":" effectively locks the code out of pgsql.

also, a special tag of "-all-" will allow access to all databases.

--
[ Jim Mercer        jim@reptiles.org         +1 416 410-5633 ]
[          I want to live forever, or die trying.            ]

В списке pgsql-general по дате отправления:

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: [HACKERS] Performance while loading data and indexing
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Performance while loading data and indexing