On Thu, 16 Mar 2000, KOOPMAN,JON (A-SantaClara,ex1) wrote:
> Thanks for the quick response,
>
> o Possibly add a permission structure to database level ACL
> that can turn off read privilege to a database to certain
> /all users. Is there any reason to limit database
> connectivity different than grant/revoke on individual
> database objects?
>
If I good understand you, you want privilage like ACL for DB?
The PostgreSQL check access to database *out* of SQL engine - connect access
control postmaster ant it is before postgres start. The postmaste knows
pg_shadow/hba_conf only, it not allow work with standard relation routines.
A solution is remove access check to postgresql layout and check it after
fork(), but is it effective?
Karel
