Encryption of data at rest is really only protection against someone stealing the data when it’s at rest. That sounds obvious but it’s key.
To steal DB data at rest the thief needs access to the DB files or hardware. In reality that means it’s an attack at the OS/physical.
You are assuming encryption at rest can only happen at the disk level. Encryption in the DB at application level prevents that. Even physical / OS access will not allow access. Take a look at Oracle TDE as an example.
To be useful the data needs to be decrypted, by he DB before being given anywhere, and probably encrypted again for transport. This is the weak point. Oddly enough if you don’t encrypt data at rest the weak point is the same point.
So if you encrypt data at rest you are strengthening an already strong point in the chain.
No, if the DB is transmitting data to another system/application over TLS etc. then it encrypts the packets within the application, before it leaves the DB. There is no point outside the application where it appears in plain text.
If you don't encrypt at rest then anyone with physical or logical access to the file store holding the data can read it. Thats the weak point. Full disk encryption works for anyone stealing the hardware or not having appropriate OS rights on the system, but doesn't protect against rogue sys admins etc. Encryption at the DB application level, such as Oracle TDE, makes sure that only those DB users and admins with appropriate access can read the data.
Yes, those users could in theory copy the data in plain text form to another location via copy/paste, exporting etc. but your DB users should be trusted and trained not to do that and the application / system config should also prevent them from doing it. They should also only have access to those tables etc in the DB that they actually need access to for the role. This is why account security is so important and why phishing / social engineering attacks can be so effective.
IMO it’s a waste of time and effort. And user credential protection for the DB admins is still the best way to improve data protection.
No, again, if you don't encrypt at rest, preferably at the DB level then you leave your data open to any who gains access to the files. Legitimately or otherwise.
The only time that rest encryption makes real sense is when you perceive the threat to be the OS admins. And bluntly if they’re the problem then you’re ****ed.
That's why you encrypt at the application level and not the OS level. You need encryption at rest in the DB rather than the OS to meet your Data Protection commitments to only allow access to the data by those who actually require that access. SysAdmins / Support staff have no reason to be looking at personal data and should not be able to. Encrypt the DB at the application level and not the OS level and you can achieve that. DBA's should be someone on the same team as the DB users and vetted for access in the same way.
Combine encryption in the application and good account security with properly configured transaction logging and you are mitigating the vast majority of the risks.