On 25/09/2006, at 9:37 PM, Andrew Cameron wrote:

How do you restrict access to the main patient db but still allow web access
the the appointments ?
Seems scarey to me.

Nah, with any SQL you can:

grant select,update on database.appointments to [EMAIL PROTECTED] identified by 'password';

without giving any access to other tables. This is MySQL syntax but you can do it with any modern database.

Peter.
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk

Reply via email to