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
Datafile RTD Excel Add-In
Viewed 8282 times since Mon, Nov 25, 2013
ProFiler Options
Viewed 1751 times since Thu, Jul 5, 2012
Data Interchange-Wildcards in Input Filename
Viewed 1986 times since Wed, Jun 13, 2012
Input File Structure - Stock Batch Update
Viewed 1656 times since Thu, Jul 5, 2012
System Status - Stock Batch Update
Viewed 1635 times since Thu, Jul 5, 2012
Input File Structure - Sales/Purchase Batch Updates
Viewed 1857 times since Thu, Jul 5, 2012
Data Interchange Omit First Row from Import
Viewed 2077 times since Fri, May 27, 2016
Calling a Batch Update Definition - Profiler
Viewed 1994 times since Thu, Jul 5, 2012
Batch Update Processing - Job Costing Batch Update
Viewed 1736 times since Thu, Jul 5, 2012
Stock Batch Update
Viewed 1638 times since Thu, Jul 5, 2012