>TABLE: Users >UserId RoleId FullName >----------- ----------- ------------------- >37 31 Gerald Ford >38 32 George Washingtion >39 32 William Cinton >40 33 Thomas Jefferson >41 33 John Kennedy >42 33 Ronald Reagan > > >TABLE: Roles >RoleId RoleName >----------- ------------- >31 Administrtor >32 Shipping >33 Receiving > > >TABLE: Rights >RightId RightName RightCode Access >----------- ------------------------------------------------ ------ >10 Login login 1 >11 View Ship Items vw_shipitems 1 >12 View Shipping Inventory vw_shipinv 1 >13 View Shipping Reports vw_shiprpts 1 >14 View Receive Items vw_rcvitems 1 >15 View Transfer Items vw_xferitems 1 >16 View Relocate Items vw_rlocitems 1 >17 View Receiving Inventory vw_rcvinv 1 >18 View Receiving Reports vw_rcvrpts 1 > > >TABLE: RoleRights >RoleRightId RoleId RightId Access >----------- ----------- --------- ------ >16 32 10 1 >17 32 11 1 >18 32 12 1 >19 32 13 1 >20 33 10 1 >21 33 14 0 >22 33 15 1 >23 33 16 0 >24 33 17 1 >25 33 18 1 > > >TABLE: UserRights >UserRightId UserId RightId Access >----------- ----------- --------- ------ >1 37 15 0 >>
>TABLE: RoleRights >RoleRightId RoleId RightId Access >----------- ----------- --------- ------ >16 32 10 1 >17 32 11 1 >18 32 12 1 >19 32 13 1 >20 33 10 1 >21 33 14 0 >1 33 15 0 <<--- This row was obtained from UserRights >23 33 16 0 >24 33 17 1 >25 33 18 1 >