Which of your components is the database client?
Is this something, you want to avoid?
Is it a WebApp or Android app?
do you want to have a column, that only a specific user can see?
Which framework did you write your app (Spring Boot, Grails, GWT, Vaadin, …)?
Spring Data JPA, JDBC, …)?
Oracle, MongoDB, Postgress, …)?
Which of your components is the database client?
https://docs.microsoft.com/en-us/sql/connect/jdbc/using-always-encrypted-with-the-jdbc-driver?view=sql-server-ver16#controlling-the-performance-impact-of-always-encrypted
Learn how to use Always Encrypted with the JDBC driver to encrypt sensitive data on the server.
I didnt understand your question
Is this something, you want to avoid? I mean, you want all users to have access, or you don’t want all users to have access?
I also need your answers to these questions in order to help you:
1. Is it a WebApp or Android app?
2. Which framework did you write your app (Spring Boot, Grails, GWT, Vaadin, …)?
3. How is your app connecting to the database (e.g. Spring Data JPA, JDBC, …)?
4. What Database do you use (e.g. Oracle, MongoDB, Postgress, …)?
Action: Muted 🔇
Generated Always Encrypted only to Column Age, Column Name is plain text.
Table X
Column Name | Column Age
Rita | 50
João | 20
______________________
User X (can not see age)
User Y (can see age)
I also need your answers to these questions in order to help you:
1. Is it a WebApp or Android app?
2. Which framework did you write your app (Spring Boot, Grails, GWT, Vaadin, …)?
3. How is your app connecting to the database (e.g. Spring Data JPA, JDBC, …)?
4. What Database do you use (e.g. Oracle, MongoDB, Postgress, …)?
1. WebApp
2. Adoptopen JDK 8 (LTS) (Open JDK 8 x64), Hibernate 5.6
3. JDBC Driver Version 8.4
4. SQL Server
Generated Always Encrypted only to Column Age, Column Name is plain text.
Table X
Column Name | Column Age
Rita | 50
João | 20
______________________
User X (can not see age)
User Y (can see age)
I still don’t understand 100% the behavior you want to implement….do you want to have a column, that only a specific user can see? Or do you want to have specific values that only the user connected to the dataset can see? Or do you want all users to see all the data?
Generated Always Encrypted (certificate) only to Column Age, Column Name is plain text.
Table X
Column Name | Column Age
Rita | 50
João | 20
Front end (view) User X (can not see age):
Column Name: Rita
Column Age: 8324u32jrjmfdmasdmads (encrypted)
Front end (view) User Y (can see age):
Column Name: Rita
Column Age: 50