Anyone on the network has access to the directory and can read and write data. How do I restrict one user to read only access to a file while others will have read/write access to that dbf file at that time?

On Friday, June 9, 2023 at 7:21:26 AM UTC-4, Tomasz Ziemba wrote:
> Anyone on the network has access to the directory and can read and write data. How do I restrict one user to read only access to a file while others will have read/write access to that dbf file at that time?
Hello Ziemba;

I find the best solution for that, under Harbour, is using ADS Server or ADS Local. With ADS you don't place your tables on a share. They are placed on a NON-SHARED directory on the server running ADS and only ADS has access to the tables. Your application connects to the ADS service on the server and data is sent back and forth between the server and the app via TPC socket connection.

You can even create users using ADS data dictionary and grant different permissions to each user.

While your data is placed on a shared directory, it can be deleted, stolen, overwritten, in danger -period.

Il giorno venerdì 9 giugno 2023 alle 18:16:24 UTC+2 Reinaldo ha scritto:
> On Friday, June 9, 2023 at 7:21:26 AM UTC-4, Tomasz Ziemba wrote:
> > Anyone on the network has access to the directory and can read and write data. How do I restrict one user to read only access to a file while others will have read/write access to that dbf file at that time?
> Hello Ziemba;
>
I manage privileges at application-level. A dbf table that collects users and credentials to the application. For every user a dbf table with all other dbf's names and privileges (lCanRead, lCanInsert, lCanModify, lCanDelete).. If a user has read-only privileges on a certain table simply don't show the 'new' record', 'update' and 'delete' button and so on.
Once you have created your structure and classes you can apply in all your apps