Currently I have a database that has multilevel user access meaning that I have a (Admin, User, Other) user access option? All three users will have access to the same backend data but all three will have a different frontend form. Now i want to use Sql server to backup my backend table and I want use Citrix to host my frontend forms. How could I successfully do this?
Keep in mind:
there is only 1 person with "Admin" rights, he can Update,add,delete
there could be multiple "Users" at one time, they can only add
there could be multiple "Others" at one time, they can only view