Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stopping operator from emaling tables
Message
 
 
To
19/02/2010 16:29:41
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01449961
Message ID:
01450103
Views:
36
Hi Naoto

Yes, the customer is also looking at upgrading the data files to SQL2008 "sometime n the future". The files are enormous and complex so would be no quick task but is definately a way forward.

Many thx to all for your advice

Rob


>If this was *nix, then I'd say simply set the owership of the program file and the data to those of a priveleged user. The permissions on the data files can then be set so that privleged user can access them, but not standard user. Then set the setuid bit attribute for the program (so that when it is run it runs with the identity of the priveleged user who can access the data)... Of course since it's likely we're talking about Windows this isn't going to help much... ... at least not directly...
>
>Have you considered using SQL server as the backend? In such a configuration it's possible to configure things so that user doesn't have direct access to the data (as would be the case with DBFs), but still be able to access it from within the program. Of course this generally means you'll need to make changes to your program... You could likely even use the Express edition of MS-SQL.
Rob
Previous
Reply
Map
View

Click here to load this message in the networking platform