cache.enabled=true
cache.size=20000
cache.ttl=10800000
sql.template.role = select * from VW_ACCESS_RIGHT_BY_ROLE \
                    where USERPRINCIPAL = :UserName \
                    and AGENT = :ApplicationName \
                    and ResourceType = :ResourceTypeName \
                    and ResourceRecord = :ResourceName \
                    and (ACCESSRIGHT = :Operation or ACCESSRIGHT = 'ANY')
sql.template.attr = select * from VW_ACCESS_RIGHT_BY_RESTYPE \
                    where USERPRINCIPAL = :UserName \
                    and PLATFORM = :PlatformName \
                    and RESOURCETYPE = :ResourceTypeName \
                                        and (ACCESSRIGHT = :Operation or ACCESSRIGHT = 'ANY')

sql.template.code = SELECT * \
  FROM (  SELECT mda.VALUE \
            FROM \
                 (SELECT \
                             d.DEPARTMENT_ID, \
                             LEVEL AS TreeLevel \
                        FROM DEPARTMENT d \
                  CONNECT BY PRIOR d.PARENT_ID = d.DEPARTMENT_ID start with d.DEPARTMENT_ID in \
                 (select d.department_id from USER_ACCOUNT ua \
                 INNER JOIN SECURITY_PRINCIPAL sp \
                    ON sp.SECURITY_PRINCIPAL_ID = ua.SECURITY_PRINCIPAL_ID \
                 INNER JOIN \
                 M_SECURITY_PRINCIPAL_DATA mspd \
                    ON     mspd.PARENT_ID = sp.SECURITY_PRINCIPAL_ID \
                       AND mspd.KEY = N'Principal.SystemName' \
                 INNER JOIN PERSONAGE pers \
                    ON ua.PERSONAGE_ID = pers.PERSONAGE_ID \
                 INNER JOIN POST pst ON pst.POST_ID = pers.POST_ID \
                 INNER JOIN DEPARTMENT d ON d.DEPARTMENT_ID = pst.DEPARTMENT_ID \
                 where UPPER (mspd.VALUE) = upper(:UserName) \
                 )  \
                    ORDER BY LEVEL) TreeDepartments \
                 INNER JOIN M_DEPARTMENT_DATA mda \
                    ON mda.PARENT_ID = TreeDepartments.DEPARTMENT_ID \
           WHERE MDA.KEY = N'ExternalID' \
        ORDER BY TreeDepartments.TreeLevel ASC) \
 WHERE ROWNUM = 1

resourceAttr=UserOrgID