Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 To: Joseph Dumon
  
 Manila
 
 Joseph Dumon
 Tags
Subject: RE: Natvie Tables "Another Option !"
Thread ID: 22714 Message ID: 22837 # Views: 35 # Ratings: 0
Version: Visual FoxPro 8 Category: Databases, Tables and SQL Server
Date: Monday, April 28, 2003 3:51:30 AM         
   


> > > > Put it on a server running an NTFS file system (or a Linux Samba share) and then only give access to the users you want to have access.
> > >
> > > Ah thanks for posting that. I did not think of it in my post.
> > > --
> > > Eric den Doop
> > > www.foxite.com - The Home Of The Visual FoxPro Experts
> >
> > Actually I wasn't sure either if he meant encryption or user rights, until I read it a few times. :)
>
> Thank you both for your answers. I'm considering trying both (LINUX SAMBA SHARE / MySQL) to prevent users from opening/manipulating the databases outside the application. I'd be grateful should you have more information to share on this subject.
>
> Thanks again.
>
> Joseph Dumon


Hi,
In VFP 8.0 you can inside the database containers properties enable Set events on.
Then in the BeforeOpenTable event code in your own password code. In this way
the database is password protected and the tables cannot be opened unless you
have the admin. password.

I have coded many application with Add, Edit and Delete persmissions. In these cases
I have a VFP table with the user id and password in them and a module to maintain
this user table. In this table I can have fields with logical flags set stored as memory
variables in the running application that enable, or disable the Add, Edit and Delete
command buttons on each form. If I want this security at a table level I have to add
the table name into this user table and then with the DBF() funtion determine what
table is being accessed and code the logic to allow Add, Edit, Delete capabilities
down to a user login level.

This is an option for you all from within native VFP code, and really not that hard to
code.

Pete from the Great White North. (Only in Canada, ay.) Over and Out ...


COMPLETE THREAD

Natvie Tables Posted by Joseph Dumon @ 4/24/2003 9:48:29 AM
RE: Natvie Tables Posted by Eric den Doop @ 4/24/2003 9:57:51 AM
RE: Natvie Tables Posted by Kev InAz @ 4/24/2003 9:59:36 AM
RE: Natvie Tables Posted by Eric den Doop @ 4/24/2003 10:02:32 AM
RE: Natvie Tables Posted by Kev InAz @ 4/24/2003 10:07:33 AM
RE: Natvie Tables Posted by Joseph Dumon @ 4/25/2003 4:33:10 AM
RE: Natvie Tables "Another Option !" Posted by Pete Sass @ 4/28/2003 3:51:30 AM
RE: Native Tables "Another Option !" Posted by Joseph Dumon @ 4/30/2003 7:41:17 AM