views:

280

answers:

2

As the title suggests, does anyone know if such a thing exists?

+1  A: 

It looks like the Postgres Veil project does this.

Veil is a data security add-on for Postgres. It provides an API allowing you to control access to data at the row, or even column, level. Different users will be able to run the same query and see different results. Other database vendors describe this as a Virtual Private Database.

zodeus
+1  A: 

You could do something like it with views/rules of the data. Also, 8.4 has column level permissions iirc.

MkV