Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MSDE Hoax!!!
Message
From
01/06/1999 09:32:10
 
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00223796
Message ID:
00224888
Views:
23
>Hi Jim,
>
>With regard to security, MSDE uses NT's security. However, if you use stored procedures, you can roll your own security. This is the nice thing about server back-ends. For instance, you set things up so that no direct updates to tables can occur. Rather, if you wish to update, delete, or add data, you can use stored procs for all of these items. In MSDE, an ID and password can be passed to each Tx. In the SQL-Server DB, you can have a users table. Does this add overhead? Sure does. However, it is a small price to pay to have secure data.
>
>This would address the issues for Win 9x.
>
>

Thanks John. I should have thought about this because it is one of the ways to enforce security in VFP. I guess my head was thinking too much toward the "SQL Server way".
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform