Re: Multiple Access to Database

I believe you would set that up through PHP.

Best,
Karl


On Jan 14, 2012, at 9:55 PM, Ethan Rosenberg wrote:

> Dear List -
>
> I have a database:
>
> mysql> show tables;
> +---------------------+
> | Tables_in_hospital2 |
> +---------------------+
> | Intake3             |
> | Visit3              |
> +---------------------+
>
>
> mysql> describe Intake3;
> +--------+-------------+------+-----+---------+-------+
> | Field  | Type        | Null | Key | Default | Extra |
> +--------+-------------+------+-----+---------+-------+
> | Site   | varchar(6)  | NO   | PRI |         |       |
> | MedRec | int(6)      | NO   | PRI | NULL    |       |
> | Fname  | varchar(15) | YES  |     | NULL    |       |
> | Lname  | varchar(30) | YES  |     | NULL    |       |
> | Phone  | varchar(30) | YES  |     | NULL    |       |
> | Height | int(4)      | YES  |     | NULL    |       |
> | Sex    | char(7)     | YES  |     | NULL    |       |
> | Hx     | text        | YES  |     | NULL    |       |
> +--------+-------------+------+-----+---------+-------+
>
> mysql> describe Visit3;
> +--------+--------------+------+-----+---------+----------------+
> | Field  | Type         | Null | Key | Default | Extra          |
> +--------+--------------+------+-----+---------+----------------+
> | Indx   | int(4)       | NO   | PRI | NULL    | auto_increment |
> | Site   | varchar(6)   | YES  |     | NULL    |                |
> | MedRec | int(6)       | YES  |     | NULL    |                |
> | Notes  | text         | YES  |     | NULL    |                |
> | Weight | int(4)       | YES  |     | NULL    |                |
> | BMI    | decimal(3,1) | YES  |     | NULL    |                |
> | Date   | date         | YES  |     | NULL    |                |
> +--------+--------------+------+-----+---------+----------------+
>
> 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
>
>
>
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

Karl DeSaulniers
Design Drumm
http://designdrumm.com


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php