..and when you've read all that, go here: http://www.mysql.com/downloads/workbench/ Much easier than doing it all on the command line! Toby -----Original Message----- From: David Robley [mailto:robleyd@xxxxxxxxxxx] Sent: Sunday, January 15, 2012 10:46 AM To: php-db@xxxxxxxxxxxxx Subject: Re: Multiple Access to Database Ethan Rosenberg wrote: > Dear List - > > I have a database: <snip> > I want Bob to have access to all tables and fields, with all privileges. > I want John to have read access to Visit3: fields [Site, MedRec, > Weight, BMI] > > 1] How do I do it? > 2] In the case that I have two users with write access to a table, how > do I lock the tables/fields so that the two users can not change the > same varible at the same time? > > Thanks. > > Ethan Start with http://dev.mysql.com/doc/refman/5.5/en/privilege-system.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
