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.<br /><br />Thanks in advance for any help (*sigh* again) <br /><br />Later,<br />Paul<!--content-->
Wow, Paul! I guess no one has an answer for you.<br /><br />My suggestion would have to be to look at a MySQL forum for your answer.<br /><br />Here's a good one: <a href="http://www.sitepointforums.com" target="_blank">http://www.sitepointforums.com</a><br /><br />Please let us know what you find.<br />Lianna<!--content-->
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. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/wink.gif" style="vertical-align:middle" emoid="
" border="0" alt="wink.gif" /><!--content-->
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 <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/ohmy.gif" style="vertical-align:middle" emoid="
" border="0" alt="ohmy.gif" /> Lo and behold, there's an SQL command "GRANT" that will do anything I wanted to do <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="
" border="0" alt="biggrin.gif" /> (insert pic of Paul doing the snoopy happy-dance here) ...<br /><br />Thanks again, I'm sure there will be many more questions to follow as I manage to mangle a perfectly good web-account !<br /><br />Later,<br />Paul<!--content-->
<img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/laugh.gif" style="vertical-align:middle" emoid=":lol:" border="0" alt="laugh.gif" /> <br />Hey, Paul if you screw it up too bad, we can always just reprovision your account and let you start over! <br /> <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/laugh.gif" style="vertical-align:middle" emoid=":lol:" border="0" alt="laugh.gif" /> <br /><br />"If all else fails, read the directions."<br />"If all else fails, start over."<br />"If all else fails, go to bed"<br />"If all else fails, go to church"<br /><br />....anybody care to add their fav?<br /> <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/laugh.gif" style="vertical-align:middle" emoid=":lol:" border="0" alt="laugh.gif" /> <br />Lianna<!--content-->
If you have the book, you're the expert!<!--content-->
LOL adding my new favorite:<br /><br />If all else fails, post on the totalchoice forums <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/tongue.gif" style="vertical-align:middle" emoid="
" border="0" alt="tongue.gif" /> <br /><br />Thanks again all!<br /><br />Later,<br />Paul<!--content-->
<!--coloro:blue--><span style="color:blue"><!--/coloro-->Good one!<!--colorc--></span><!--/colorc--><br /><br />L<!--content-->
If all else fails, blame it on someone else. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /><!--content-->
If all else fails, make sure it's plugged in. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="" border="0" alt="biggrin.gif" /><!--content-->
if all else fails, fix yourself a bowl of ice cream with hot fudge and relax --- after all, it's only a computer!<!--content-->
"I don't have to know all the answers if I know where to find them."<br /><br />Li<br />(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. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/laugh.gif" style="vertical-align:middle" emoid=":lol:" border="0" alt="laugh.gif" /> )<!--content-->
Hey! I want to go to KWs house. Ice cream and hot fudge sounds gooood.<br /><br />curtis<!--content-->
Let me know when you're in Florida and I'll have it ready the ice cream and hot fudge ready!<br />-kw<!--content-->
Watch it KW I'm already in Florida LOL ... Beachside of Melbourne, where are you?<br /><br />Later,<br />Paul<!--content-->
KW, not for a few weeks. Its Mardi Gras time. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/ph34r.gif" style="vertical-align:middle" emoid="h34r:" border="0" alt="ph34r.gif" /><!--content-->
Wow, Paul! I guess no one has an answer for you.<br /><br />My suggestion would have to be to look at a MySQL forum for your answer.<br /><br />Here's a good one: <a href="http://www.sitepointforums.com" target="_blank">http://www.sitepointforums.com</a><br /><br />Please let us know what you find.<br />Lianna<!--content-->
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. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/wink.gif" style="vertical-align:middle" emoid="
" border="0" alt="wink.gif" /><!--content-->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 <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/ohmy.gif" style="vertical-align:middle" emoid="
" border="0" alt="ohmy.gif" /> Lo and behold, there's an SQL command "GRANT" that will do anything I wanted to do <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="" border="0" alt="biggrin.gif" /> (insert pic of Paul doing the snoopy happy-dance here) ...<br /><br />Thanks again, I'm sure there will be many more questions to follow as I manage to mangle a perfectly good web-account !<br /><br />Later,<br />Paul<!--content--><img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/laugh.gif" style="vertical-align:middle" emoid=":lol:" border="0" alt="laugh.gif" /> <br />Hey, Paul if you screw it up too bad, we can always just reprovision your account and let you start over! <br /> <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/laugh.gif" style="vertical-align:middle" emoid=":lol:" border="0" alt="laugh.gif" /> <br /><br />"If all else fails, read the directions."<br />"If all else fails, start over."<br />"If all else fails, go to bed"<br />"If all else fails, go to church"<br /><br />....anybody care to add their fav?<br /> <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/laugh.gif" style="vertical-align:middle" emoid=":lol:" border="0" alt="laugh.gif" /> <br />Lianna<!--content-->
If you have the book, you're the expert!<!--content-->
LOL adding my new favorite:<br /><br />If all else fails, post on the totalchoice forums <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/tongue.gif" style="vertical-align:middle" emoid="
" border="0" alt="tongue.gif" /> <br /><br />Thanks again all!<br /><br />Later,<br />Paul<!--content--><!--coloro:blue--><span style="color:blue"><!--/coloro-->Good one!<!--colorc--></span><!--/colorc--><br /><br />L<!--content-->
If all else fails, blame it on someone else. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /><!--content-->If all else fails, make sure it's plugged in. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="
" border="0" alt="biggrin.gif" /><!--content-->if all else fails, fix yourself a bowl of ice cream with hot fudge and relax --- after all, it's only a computer!<!--content-->
"I don't have to know all the answers if I know where to find them."<br /><br />Li<br />(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. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/laugh.gif" style="vertical-align:middle" emoid=":lol:" border="0" alt="laugh.gif" /> )<!--content-->
Hey! I want to go to KWs house. Ice cream and hot fudge sounds gooood.<br /><br />curtis<!--content-->
Let me know when you're in Florida and I'll have it ready the ice cream and hot fudge ready!<br />-kw<!--content-->
Watch it KW I'm already in Florida LOL ... Beachside of Melbourne, where are you?<br /><br />Later,<br />Paul<!--content-->
KW, not for a few weeks. Its Mardi Gras time. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/ph34r.gif" style="vertical-align:middle" emoid="
h34r:" border="0" alt="ph34r.gif" /><!--content-->