1. Forum
  2. Usenet
  3. COMP.LANG.XHARBOUR

  • R/O access to .dbf file in net

    From Tomasz Ziemba@21:1/5 to All on Fri Jun 9 04:21:24 2023
    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?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Reinaldo@21:1/5 to Tomasz Ziemba on Fri Jun 9 09:16:22 2023
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Roberto Chiaiese@21:1/5 to All on Mon Jun 12 07:21:31 2023
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)