RE: [PHP-DB] Re: Multiple Access to Database
| From: | Toby Hart Dyke | Date: | Sun, 15 Jan 2012 13:04:10 +0000 |
| Subject: | RE: [PHP-DB] Re: Multiple Access to Database | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-48166@lists.php.net to get a copy of this message | ||
..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@aapt.net.au]
Sent: Sunday, January 15, 2012 10:46 AM
To: php-db@lists.php.net
Subject: [PHP-DB] 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