MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-ID: <16087.45449.309496.281238@mail.linux-delhi.org>
Date: Sat, 31 May 2003 01:01:21 +0530
To: pgsql-sql@postgresql.org
Subject: Dynamic views/permissions
From: Raj Mathur <raju@linux-delhi.org>

I'm trying to permit users access to their own records in a database.
A sample would be:

create table logins
(
        login char(8),
        name char(32),
        primary key (login)
);

When a login is added an SQL user is created simultaneously.  Now I
want the user to be able to view her own data:

create function userid() returns text as 'select current_user::text;'
  language sql;

create view loginview as select * from logins where logins.login=userid();

grant select on loginview to public;
[OR grant select on loginview to <userid>...]

However, a select * from loginview; doesn't return any rows.  Is what
I'm trying not possible at all, or am I just trying to implement it
wrong?

Regards,

-- Raju
-- 
Raj Mathur                raju@kandalaya.org      http://kandalaya.org/
       GPG: 78D4 FC67 367F 40E2 0DD5  0FEF C968 D0EF CC68 D17F
                      It is the mind that moves