How to restrict select from table with external validation?

"Vladimir A. Petrov" <vap@xxxxxxxxxx> · Mon, 10 Jul 2006 14:56:32 +0500

Hello!

I have table like

CREATE TABLE stats
(
  username varchar(256) NOT NULL,
  "time" int8 NOT NULL,
  duration int4 NOT NULL,
  phonenumber varchar(20) NOT NULL,
  and so on ...
)

I have function like

CREATE OR REPLACE FUNCTION auth("varchar", "varchar")
  RETURNS bool AS '
...
' LANGUAGE 'plperlu' VOLATILE;

where first argument is username and second is password. This function 
returns true if username and password validated successfully or false 
otherwise.

I have a user which must do only selects from table "stats".

My questions is how to restrict access on table "stats" to this user in 
way where this user will be able to select only limited set of columns 
from table "stats" and only rows with usernames for which this user 
knows correct passwords validated via auth() function call.

Any help will be appreciated.
--
Vladimir A. Petrov (aka vap)                    phone: (+7 8482) 420069
Infopac JSC. Head of the exploitation department.     http://infopac.ru
_______________________________________________________________________
^[:wq                                         ...sed libera nos a malo.