Is it possible to have an encrypted column (example EMPLOYEE_SALARY) in a table that certain users can read, but a user with DBA privileges cannot?
I've played around with putting a table in its own schema where only users assigned to a role can select from, but a user with dba privileges can still select it.
Most of our developers have DBA privs and we don't want them to have access. Would this have to be a in a seperate database where only select developers have DBA privs and share the data with the main db after different authentication?
Oracle 19c