CODEWITHSUNDEEP
databaseoracle-databasepostgresql
Hawk Kroeger
Hawk Kroeger

Reputation: 2334

Does Postgres have something similar to Oracle's Virtual Private Databases?

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

Upvotes: 3

Views: 1941

Answers (2)

Hawk Kroeger
Hawk Kroeger

Reputation: 2334

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.

Upvotes: 5

MkV
MkV

Reputation: 3096

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

Upvotes: 1

Related Questions