3 level authorization table structure RRS feed

  • Question

  • Hi ,

        I have an application, I want add a feature of maker,checker and authorize for every record in a table. I am explaining in below details.

    Ex : -

         Suppose I have one table called Employee table. There are 3 users are there. one is maker, 2nd one is checker and last one is authorize person. So when 1st user creates an employee record in database then this record is not live means this record can not be used in any transaction. Once checker is checked and authorize user is authorized this record will go live. Same thing is applicable for update and delete also. So I want a table structure how to achieve this in real time. I have designed a structure but I need a reliable and simple design. Please advice if any.

    Tuesday, September 2, 2014 11:15 AM