Mark, one last quest on this topic. Using VFP as the front end for apps on oracle data, can you still impose the user-roles, column security for read only, etc?
thanks.
>Are you saying dbfs are not as secure as oracle.database? Perhaps dbf security can only be controlled at the NT level whereas oracle has roles?
>>BTW. I use foxweb for vfp dbf's on my web intranet. Real easy.
>
>Absolutely. In Oracle, I can create a Role that restricts a user to select-only [read-only] access of a specific column [field] in a specific table. Can't do that natively in VFP because any user with VFP, Access, etc., can hack in and read any data they want. They can't do that to Oracle tables.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."
