{"id":171,"date":"2007-04-25T15:13:10","date_gmt":"2007-04-25T13:13:10","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=171"},"modified":"2012-04-03T09:54:09","modified_gmt":"2012-04-03T07:54:09","slug":"171","status":"publish","type":"post","link":"http:\/\/oracle.malin.pl\/?p=171","title":{"rendered":"SQL sprawdzenie jakie autoryzacje s\u0105 podpi\u0119te do u\u017cytkownika."},"content":{"rendered":"<p>SQL sprawdzenie jakie autoryzacje s\u0105 podpi\u0119te do u\u017cytkownika.<\/p>\n<p><!--more--><\/p>\n<pre lang='PLSQL'>\r\nselect distinct u.user_name login, u.description nazwisko, r.responsibility_name aut\r\n from fnd_user u,\r\n fnd_user_resp_groups ur,\r\n fnd_responsibility_vl r,\r\n per_people_f p\r\n where u.employee_id = p.PERSON_ID(+)\r\n AND u.user_id = ur.user_id\r\n and r.application_id = ur.responsibility_application_id\r\n and r.responsibility_id = ur.responsibility_id\r\n and nvl(ur.start_date, SYSDATE - 1) and nvl(ur.end_date, sysdate + 1) &gt; sysdate\r\n and nvl(u.start_date, SYSDATE - 1) and nvl(u.end_date, sysdate + 1) &gt; sysdate\r\n and nvl(r.start_date, SYSDATE - 1) and nvl(r.end_date, sysdate + 1) &gt; sysdate\r\n AND r.RESPONSIBILITY_NAME = 'XXX'<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SQL sprawdzenie jakie autoryzacje s\u0105 podpi\u0119te do u\u017cytkownika.<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[97],"tags":[225,226],"_links":{"self":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/171"}],"collection":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=171"}],"version-history":[{"count":6,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/171\/revisions"}],"predecessor-version":[{"id":698,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/171\/revisions\/698"}],"wp:attachment":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=171"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}