Custom security through functions.

Поиск
Список
Период
Сортировка
От Sten Daniel Sørsdal
Тема Custom security through functions.
Дата
Msg-id 43379F63.9050302@wm-access.no
обсуждение исходный текст
Список pgsql-novice
Hi

I wish it add my own layer of security based primarily on username and
password for a PHP application. Basically i wish to perform
authentication through my own PL/PGSQL function that should set some
kind of session only variable. This variable should then be used as
security token in the following functions (they work as a middle layer
between application and the actual tables performing the actual queries)
be checked for simple validity. Functions are executed with function
authors privileges only.

My problem is that i havent identified what kind of variable type (if
any) i can use that a session may not just set on it's own (can i block
this with ACL?). Perhaps some kind of temporary table? Are there any
kinds that would expire as soon as session is over?

--
Sten Daniel Sørsdal

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: View
Следующее
От: "Marc Khayat"
Дата:
Сообщение: Re: Init script