CodeIgniter Forums
securing mySQL table data - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- 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