My Pastes
Public Pastes
Layout Width
Share Pastebin
Guest
Public paste!

cojack

By: a guest | Mar 21st, 2010 | Syntax: SQL | Size: 0.30 KB | Hits: 62 | Expires: Never
Download | Raw | Embed | Report abuse
Copy text to clipboard
  1. CREATE VIEW "checkRight" AS
  2. SELECT
  3.   "allow"
  4. FROM
  5.   "rbac_privilages" p
  6. LEFT JOIN
  7.   "rbac_module" m
  8. ON
  9.   ( p."idModule" = m."idModule" )
  10. LEFT JOIN
  11.   "rbac_action" a
  12. ON
  13.   ( p."idAction" = a."idAction" )
  14. LEFT JOIN
  15.   "rbac_user_to_group" u2g
  16. ON
  17.   ( p."idGroup" = u2g."idGroup" );
create new paste | create new version of this paste RAW Paste Data