Home » Categories » Solutions by Business Process » Utilities

Data Item Access via Authority Level

Datafile Software

Data Item Access via Authority Level

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

Additional Notes

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.

Custom Fields
  • Release ID: 5.7
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Confirm Input File and Date - Sales/Purchase Batch Updates
Viewed 1787 times since Thu, Jul 5, 2012
Disputed Transactions on Allocation Import
Viewed 1672 times since Tue, Jun 12, 2012
Increased Options Allowed on the Main Menu
Viewed 98 times since Thu, Jan 9, 2025
End of Batch Update - Stock Batch Update
Viewed 1617 times since Thu, Jul 5, 2012
Data Items Cross Reference - Stock Batch Update
Viewed 1624 times since Thu, Jul 5, 2012
Input File Pathname - Stock Batch Update
Viewed 1777 times since Thu, Jul 5, 2012
Confirm Input File and Date - Job Costing Batch Update
Viewed 3248 times since Thu, Jul 5, 2012
List Matrix Entries
Viewed 1812 times since Mon, Nov 25, 2013
Omit Exclusive File Locks on DFD Import
Viewed 1920 times since Fri, Jun 8, 2012
Data Interchange Omit First Row from Import
Viewed 1996 times since Fri, May 27, 2016