SQL sprawdzenie jakie autoryzacje są podpięte do użytkownika.
SELECT DISTINCT u.user_name login, u.description nazwisko, r.responsibility_name aut
FROM fnd_user u,
fnd_user_resp_groups ur,
fnd_responsibility_vl r,
per_people_f p
WHERE u.employee_id = p.PERSON_ID(+)
AND u.user_id = ur.user_id
AND r.application_id = ur.responsibility_application_id
AND r.responsibility_id = ur.responsibility_id
AND NVL(ur.start_date, SYSDATE - 1) AND NVL(ur.end_date, SYSDATE + 1) > SYSDATE
AND NVL(u.start_date, SYSDATE - 1) AND NVL(u.end_date, SYSDATE + 1) > SYSDATE
AND NVL(r.start_date, SYSDATE - 1) AND NVL(r.end_date, SYSDATE + 1) > SYSDATE
AND r.RESPONSIBILITY_NAME = 'XXX' |
select distinct u.user_name login, u.description nazwisko, r.responsibility_name aut
from fnd_user u,
fnd_user_resp_groups ur,
fnd_responsibility_vl r,
per_people_f p
where u.employee_id = p.PERSON_ID(+)
AND u.user_id = ur.user_id
and r.application_id = ur.responsibility_application_id
and r.responsibility_id = ur.responsibility_id
and nvl(ur.start_date, SYSDATE - 1) and nvl(ur.end_date, sysdate + 1) > sysdate
and nvl(u.start_date, SYSDATE - 1) and nvl(u.end_date, sysdate + 1) > sysdate
and nvl(r.start_date, SYSDATE - 1) and nvl(r.end_date, sysdate + 1) > sysdate
AND r.RESPONSIBILITY_NAME = 'XXX'
Ten wpis został opublikowany w kategorii
SQL-ki i oznaczony tagami
kolory,
wygląd. Dodaj zakładkę do
bezpośredniego odnośnika.