security on line by line basis

From: Lorenzo Huerta <lorhuerta(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: security on line by line basis
Date: 1998-07-17 14:19:43
Message-ID: 19980717141943.14647.rocketmail@send1e.yahoomail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general


hey folks

is there a way to set postgres 6.3 up to do security on a record by
record basis?
See what i am doing is createing a database that needs several
levels of security
admin - total access to databasee
sub-admin - total access to database except for the first 2 and
last 2 entries in the database
group-admin - access to only a piece of the database based on
criteria

can i create a rule and have grant and revoke privs based on that
rule?

-lorenzo
email: lorenzo(at)nmsu(dot)edu
lorhuerta(at)yahoo(dot)com

_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Maarten Boekhold 1998-07-17 14:35:41 Re: [ADMIN] security on line by line basis
Previous Message Erik S. Peterson 1998-07-16 04:01:24 Help please: postgres on linux

Browse pgsql-general by date

  From Date Subject
Next Message Maarten Boekhold 1998-07-17 14:35:41 Re: [ADMIN] security on line by line basis
Previous Message Bruce Momjian 1998-07-17 14:05:48 Re: [GENERAL] \dt Error