What database tables should I take to find connection between a Case and permission to its reading?

Question

What database tables should I take to find connection between a Case and permission to its reading?

Answer

Every object has a permission table with the following name structure: Sys + object + Right, (for a case, it is the SySCaseRight name). The permissions are added to such tables with specifying the SySAdminUnitId (a record identifier) of SySAdminUnit (user and group table). The table contains: a RecorId  - the Id of the record that the permission is applied to, Operation - the operation of the permission, and RightLevel - the level of the permission.

SourceId contains the Id from the SysEntitySchemaRecRightSource table, which is the source of permission distribution (Owner, Assignee, Default).

RightLevel values:

      0 - Deny

      1 - CanRead

      2 - CanEdit

Operation values:

      0 - Read

      1 - Edit

      2 - Delete