CodeIgniter Forums
securing mySQL table data - Printable Version

+- CodeIgniter Forums (
+-- Forum: Using CodeIgniter (
+--- Forum: General Help (
+--- Thread: securing mySQL table data (/showthread.php?tid=78372)

securing mySQL table data - richb201 - 01-09-2021

In my app I have a bunch of tables (maybe 30). One of the tables holds important info that includes the email addresses of employees. I'd like to secure this table. Should I be relying on a mySQL feature or should I be encrypting email addresses with CI before saving them to the mySQL table?

RE: securing mySQL table data - InsiteFX - 01-09-2021

You can use MySQL owner rights to only allow yourself to access it for certain things

Like you said you could also encrypt the data.

RE: securing mySQL table data - richb201 - 01-11-2021

Thanks. I will check out owner rights. I guess encrypting the data would be best but will make it really hard to debug   Wink