From: Raj Mathur <raju@linux-delhi.org>
To: pgsql-sql@postgresql.org
Subject: Dynamic views/permissions
Date: Sat, 31 May 2003 01:01:21 +0530
Message-ID: <16087.45449.309496.281238@mail.linux-delhi.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: raju@linux-delhi.org
Subject: Re: Dynamic views/permissions
In-Reply-To: <16087.45449.309496.281238@mail.linux-delhi.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox