Paul Posted February 25, 2003 Posted February 25, 2003 Is there anyway to set up different security 'levels' for use with PHP in accessing a database? My scripts are working okay but I'd like to be able to use a password and username that doesn't allow for some operations, i.e. drop table LOL ... it seems to be a pretty logical request but I'm darned if I can find any information on setting security levels on the username level. Thanks in advance for any help (*sigh* again) Later, Paul Quote
Lianna Posted February 26, 2003 Posted February 26, 2003 Wow, Paul! I guess no one has an answer for you. My suggestion would have to be to look at a MySQL forum for your answer. Here's a good one: http://www.sitepointforums.com Please let us know what you find. Lianna Quote
rayners Posted February 26, 2003 Posted February 26, 2003 After spending a couple minutes looking through the CPanel and PhpMyAdmin interfaces, it would appear you don't have any control over database users beyond turning on and off access to your databases. I imagine that's because of how MySQL works. If you have enough access to change users specific database permissions, you could probably do it to any user on the system. And considering you're probably on a shared server, that's not exactly a good idea. Quote
Paul Posted February 26, 2003 Author Posted February 26, 2003 Thanks for the responses folks! after a full night's sleep and allowing the scotch to be absorbed I decided to try something revolutionary ... I looked at the mySQL documentation Lo and behold, there's an SQL command "GRANT" that will do anything I wanted to do (insert pic of Paul doing the snoopy happy-dance here) ... Thanks again, I'm sure there will be many more questions to follow as I manage to mangle a perfectly good web-account ! Later, Paul Quote
Lianna Posted February 26, 2003 Posted February 26, 2003 Hey, Paul if you screw it up too bad, we can always just reprovision your account and let you start over! "If all else fails, read the directions." "If all else fails, start over." "If all else fails, go to bed" "If all else fails, go to church" ....anybody care to add their fav? Lianna Quote
KevinW Posted February 26, 2003 Posted February 26, 2003 If you have the book, you're the expert! Quote
Paul Posted February 26, 2003 Author Posted February 26, 2003 LOL adding my new favorite: If all else fails, post on the totalchoice forums Thanks again all! Later, Paul Quote
TCH-Rick Posted February 26, 2003 Posted February 26, 2003 If all else fails, blame it on someone else. Quote
rayners Posted February 26, 2003 Posted February 26, 2003 If all else fails, make sure it's plugged in. Quote
KevinW Posted February 26, 2003 Posted February 26, 2003 if all else fails, fix yourself a bowl of ice cream with hot fudge and relax --- after all, it's only a computer! Quote
Lianna Posted February 26, 2003 Posted February 26, 2003 "I don't have to know all the answers if I know where to find them." Li (My Dad says this as he and my mother face off in Trivial Pursuit. Mom kindly reminds him then that it's breaking the rules to use any reference materials. ) Quote
curtis Posted February 27, 2003 Posted February 27, 2003 Hey! I want to go to KWs house. Ice cream and hot fudge sounds gooood. curtis Quote
KevinW Posted February 27, 2003 Posted February 27, 2003 Let me know when you're in Florida and I'll have it ready the ice cream and hot fudge ready! -kw Quote
Paul Posted February 27, 2003 Author Posted February 27, 2003 Watch it KW I'm already in Florida LOL ... Beachside of Melbourne, where are you? Later, Paul Quote
curtis Posted February 27, 2003 Posted February 27, 2003 KW, not for a few weeks. Its Mardi Gras time. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.