I have created TDE from sa user and I logged in with another user with same rights. But all DB objects were looking unencrypted.

My Question is that When this database would be uploaded at Liver Server then how it would be protected from attacks. Should I use other users for this? I want to test these scenarios at dev environment before shift it to Live.

I think you understand my Question.

Thanks for reply.