+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: Full or Limited Database Privileges (/showthread.php?tid=40499)
Full or Limited Database Privileges - El Forum - 04-10-2011
[eluser]digity[/eluser]
For the database config, what kind of privileges should the mysql user have? Limited privileges (i.e., SELECT, INSERT, UPDATE, etc.) or root or near-root privileges?
Full or Limited Database Privileges - El Forum - 04-10-2011
[eluser]cahva[/eluser]
Always limited privileges to the database(s) that it uses.
Full or Limited Database Privileges - El Forum - 04-11-2011
[eluser]digity[/eluser]
So does that mean my app built on CI should never need to DELETE, DROP, CREATE, ALTER, etc.?
Full or Limited Database Privileges - El Forum - 04-11-2011
[eluser]wh1tel1te[/eluser]
You should only give your user enough privileges to do its job, and nothing more. This usually is SELECT, UPDATE and DELETE. If you find you need more privileges later on, just grant it.
Full or Limited Database Privileges - El Forum - 04-11-2011
[eluser]digity[/eluser]
Thanks you two!