Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do password protect a table or a entire database
Message
From
23/07/2000 12:38:10
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00395980
Message ID:
00395983
Views:
9
>i want password protect a table or a entire database can can anybody help

You can look a Cryptor, an encryption product, available from Hallogram (www.hallogram.com)

If the database is kept on an NT/Win2K server using NTFS or Novell NetWare server, you can use operating system level protections on a per-user basis for any file; this would allow you to restrict access to files or folders on the basis of the user login. Neither NetWare or NTFS provide finer control than file-level restriction, but both will provide file-level restriction based on User ID or Group membership. This is done with the OS file access permissions, and is external to VFP. Win2K using the EFS provides the best protection against copying where users are granted read access to data, with the operating system providing encryption of the data on the fly when accessed through the server.

Real security would require that the tables get managed by a database backend such as Oracle or SQL Server, with the backend providing its own security implementation.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Reply
Map
View

Click here to load this message in the networking platform