×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Pervasive v9x question

Pervasive v9x question

Pervasive v9x question

(OP)
One of the thing I have always disliked about Pervasive SQL versus MS SQL is that each table is also a file.  Therefore, is no one is actively using the file from pervasive or an application using the pervasive engine, all I need to do is open windows explorer, right click, send to, removeable USB storage device ad viola!  I walkout with your customer list or other proprietary info.

In MS SQL this is not possible as there is only one file - the .mdb file - and it is always kept busy by SQL Server.

So my question is, has Pervasive v9x addressed this shortcoming?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz

RE: Pervasive v9x question

Not directly.  There is no monolithic database file for Pervasive (and I doubt there ever will be).  That being said, PSQL 8.5 and later have new security features.  You can, by enabling database security and changing the authentication mode from "Classic" to "Database", eliminate the rights of the user to the data files and DDFs.
Your app may need to change to support the new security model though.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Pervasive v9x question

(OP)
Mirthiel,

Thanks for the great answer, as usual.  

On the App I am talking about (Macola) this is indeed the problem.  When a user posts an invoice for example, they are deleteing records from an open orders table.  If they add a new item or customer, they write records to a Macola table.  So by definition they must have read, write, delete rights to the files.  Essentially they need full rights to these files.

Is there a way to grant these rights when working through the App, but deny them the ability to get to these files through windows explorer?  I somehow doubt it but would love to hear your ideas on this.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz

RE: Pervasive v9x question

The only way to remove rights through explorer is to use the new security model.  The default behavior uses the OS for authentication so the user has to have the appropriate rights.  

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close