Access Denied is a systems message that you get when yo try to access a view from a menu and you do not have the authority to do it.
To achieve this functionality we are going to have to maintain the following tables :
1. The establishment table
This maps out the type of people within the organisation. In the golf hub there will be :
1. The Hyper Administrator - Master Password Owner
2. Administrator = has update access to the golf hub
3. Competition Organiser - Self Explanatory
4. User - Information Finder
To map function to establishment we are going to have to maintain a personnel record
1 Personnel Table Containing :
1.1 Email Address
1.3 Establishment Code
To control access we will need the Access Control Table. This will map View to Establishment code.
The Table will contain :
1. Establishment Code
People with be require to sign in to the dsystem giving us access to their e'mail address and password.
A click event on the menu will determine what view they are trying tp access. If the parameters tsete that they do not have access the system message access denied will need to be displayed - This meand the system message Text box will neeed to be added to all views.
As a person will want to be a user as well as an user there will be an Acting Down Feature where a secondary E.mail Address and password is added to the personnel record.
As a user may want to Act UP to be a Competition Organiser or Administrator the will be acting up details - E'Mail Password as elements to the Personnel file. Users will be allowed a maximum of 2 acting up codes - Users will not be allowed to act us as the Hyper Administrator this is reserved for the Red Camel Team.
As this processing is going to be used by Payroll Application in Subsequent releases we will start to record Hays table Grade and Scale As part of the Establishment Table.
This amend that there will be a Payroll Table with:
1. Pay Grade
2. Pay Scale
3. Annual Salary
At some time we will introduce Job Accounting and start to record the time that a person is using each view and calculate the cost using payroll hays table information.
This will depend if Richard can provide Forms(View) Load / Forms(View) Exit functions in MVC.
This is a technical Question beyond my experience so the development design of Job Accounting will be down to Richard and Paul. All I know is that there will have to be a table with :
1. Userid (E'Mail)
3 Start Time
4 End Time
5 Cost of Transaction