BorlandTalk.com

Marcelo · Guest

Hi
I have remote datamodule with a master and details tables, I am implementing
a user access control, so I have a table with info about each user rights to
insert, update and delete records for each table , I manage this using the
poDisables... options of each provider, but I want to give, say update
access to a detail table but not to the master. How should I do this? I
tought of clearing the corresponding update sql statements of the detail
table but doesnt seem elegant.
Another question: Why do I have to open the detail tables explicity in the
server to update records? Im using nesteddatasets and they work fine for
reading, but do not update nor delete nor insert, saying the table is closed
Thanks, Marcelo.