CIA Solutions Help Desk

In SQL there are 5 tables that give permissions:

1. For All:
   • Database: 
     1. CIA
        1. "tblUser" For access to CIA and HLO, in tblUsers, create a profile.
           
2. For CIA:
   • Database:
     1. CIA:
        1. "tblAuthorization" For security authorizations for each property under them.
3. For HLO:
   • Database:
     1. Company:
        1. "tblHotelRights" To assign properties to each profile.  
           • If user is not in tblHotelRights they will not show up in the HLO user list.
        2. "tblLaborDepartmentRights" To give them rights to each department, the jobs and salaries within each department. 
        3. "tblRPTRights" Reports and processes rights