VicToMeyeZR Posted May 10, 2009 Share Posted May 10, 2009 Lock a DB Table. I have been trying to find out if it is possible to lock a specific table so that it can't be modified from a web site? I can't find any data on it. 0 Quote Link to comment Share on other sites More sharing options...
othellotech Posted May 10, 2009 Share Posted May 10, 2009 web-sites dont update tables, queries do and yes, mysql supports a rudimentary form of locking. 0 Quote Link to comment Share on other sites More sharing options...
VicToMeyeZR Posted May 10, 2009 Author Share Posted May 10, 2009 ok, thats good, so............ Now that I know that you can (which is what I thought to begin with) how do you do it? 0 Quote Link to comment Share on other sites More sharing options...
bear Posted May 10, 2009 Share Posted May 10, 2009 One table out of many in a database? What sql type and version (Oracle, mysql, mssql...) and what storage engine are you using (INNO, MYISAM...)? If it's the whole DB and not just a table, run the queries as a user with only read permissions (SELECT, and not UPDATE, etc). 0 Quote Link to comment Share on other sites More sharing options...
VicToMeyeZR Posted May 11, 2009 Author Share Posted May 11, 2009 Thats not what I mean. OK, here is what I want to accomplish. I want to BLOCK the paypal payment address NOT to be able to be changed. ONLY from logging into phpMyAdmin only. I don't want WHMCS to be able to change the paypal payment information from the WEB Panel. It MySQL 5.0+ 0 Quote Link to comment Share on other sites More sharing options...
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.