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