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 |