This option allows you to set, via a database.ini, the authority level for display and access to data items such as the cost price.
If you create a text file in the same location as the database – so for example, if you have a file ABC-STA.DFD in the DATA folder create a ABC-STA.INI in the same folder – this is used to set the authority levels. The format is:
Data-Item-Number,AUTH=n
So if you wished that the cost price on the stock file is only shown to users with authority level 5 or above then you would set an entry as:
016,AUTH=5
q This option affects screen access to the nominated fields – reports will still include these items and should be protected in the normal manner (authority level and password).
q Where the purpose of a procedure requires the field(s) concerned, for example if blocking display of cost price then no point in entering purchase orders, then the procedure should be restricted in the normal manner.
q Remember that the same value can be held in multiple databases – the cost price on the stock file, for example, will be recorded on the stock transactions file, the purchase order details file, the sales order detail file, etc – so you would need a database INI for each of these databases.
Article ID: 359
Created On: Wed, Jun 13, 2012 at 3:49 PM
Last Updated On: Wed, Jun 14, 2023 at 4:20 PM
Online URL: https://kb.datafile.co.uk/article/data-item-access-via-authority-level-359.html