Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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

like image 872
Hawk Kroeger Avatar asked Aug 10 '26 04:08

Hawk Kroeger


2 Answers

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.

like image 193
Hawk Kroeger Avatar answered Aug 13 '26 06:08

Hawk Kroeger


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

like image 37
MkV Avatar answered Aug 13 '26 06:08

MkV



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!