List:General Discussion« Previous MessageNext Message »
From:Jason Pruim Date:September 19 2007 2:23pm
Subject:privileges
View as plain text  
Hi everyone,

Just getting into database stuff a little bit, and wanted to double  
check something with you guys.

I have a database, which has 2 tables, I have created a user using  
this syntax: grant select, update, delete on dbname.table to  
'me'@'localhost' identified by 'mypass';

then I also added access to another table: grant select on  
dbname.othertable to 'me'@'localhost' identified by 'mypass';

the "other table" is used to store local accounts to a online  
database, and my php script uses SELECT to check to see if they are  
listed and if so grant them access. No one is accessing the database  
directly except for me, and I would like to keep it that way.

Given the user that I created, is there anything else I need to worry  
about? I only want local requests to be able to interface with the  
database. I don't need Joe Blow for indiana to have direct access :)

Oh, and do I specifically have to disallow certain privileges if all  
I want them to be able to do is delete, select or update records?


--

Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424
www.raoset.com
japruim@stripped



Thread
privilegesJason Pruim19 Sep