cojack

CREATE VIEW "checkRight" AS
SELECT
  "allow"
FROM
  "rbac_privilages" p
LEFT JOIN
  "rbac_module" m
ON
  ( p."idModule" = m."idModule" )
LEFT JOIN
  "rbac_action" a
ON
  ( p."idAction" = a."idAction" )
LEFT JOIN
  "rbac_user_to_group" u2g
ON
  ( p."idGroup" = u2g."idGroup" );