RE: Re: Multiple Access to Database

["Toby Hart Dyke" <toby@xxxxxxxxxxxx>]

..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