Howdie,
We have multiple users with access to multiple systems and we are trying to design a DB to capture all of this information.
To date we have Table_MasterData that contains the User_Id and the Systems (A,B etc).
We also have tables for each System (A,B etc) that details specific permissions for the user by User_Id and these additional tables are then linked by the User_Id to the Table_MasterData.
In addition to this there is also a weekly Leavers excel spreadsheet that will be received and loaded into the Table_Leavers.
Table_Leavers
User_ID
Date_Left
Table_MasterData
User_ID
SystemA
SystemB
Table_SystemA
User_ID
Profile
Table_SystemB
User_ID
Profile
What we are trying to achieve is to create a leavers process that will highlight those leavers on the MasterData and Systems tables and then delete the users from all tables where there is a record for that User_Id.
I have searched the forums but cannot find a solution to this.
Does anyone have any suggestions?
Thanks
We have multiple users with access to multiple systems and we are trying to design a DB to capture all of this information.
To date we have Table_MasterData that contains the User_Id and the Systems (A,B etc).
We also have tables for each System (A,B etc) that details specific permissions for the user by User_Id and these additional tables are then linked by the User_Id to the Table_MasterData.
In addition to this there is also a weekly Leavers excel spreadsheet that will be received and loaded into the Table_Leavers.
Table_Leavers
User_ID
Date_Left
Table_MasterData
User_ID
SystemA
SystemB
Table_SystemA
User_ID
Profile
Table_SystemB
User_ID
Profile
What we are trying to achieve is to create a leavers process that will highlight those leavers on the MasterData and Systems tables and then delete the users from all tables where there is a record for that User_Id.
I have searched the forums but cannot find a solution to this.
Does anyone have any suggestions?
Thanks
