Personas

To document and explain the behaviour of this extension, we use common fictional characters as placeholders.

• Alice is a normal postgres user. She is allowed to read the encrypted columns

• Bob is a normal postgres user. He is NOT allowed to read the encrypted columns

• Owen is the owner of the database

• Rodney is the Linux superuser. He is root on the host server. He can act as the postgres superuser. He is fully trusted.

• Sue is a postgres superuser. She is fully trusted. She is able to create database users and define a FetchKey method for them.