declare
cursor c_role(p_username varchar2)
is
select USERNAME
, rtrim ( xmlagg (xmlelement (c,GRANTED_ROLE || ',') ORDER BY GRANTED_ROLE).extract ('//text()'), ',' ) AS role_list
from user_role_privs
where USERNAME=p_username
group by USERNAME;
begin
htp.p('You are :: '
||APEX_UTIL.GET_FIRST_NAME(p_username => APEX_CUSTOM_AUTH.GET_USERNAME )
||' '
||APEX_UTIL.GET_LAST_NAME(p_username => APEX_CUSTOM_AUTH.GET_USERNAME )
||'
');
htp.p('You are the APEX user :: '||APEX_CUSTOM_AUTH.GET_USERNAME ||'');
for rec in c_role(p_username => APEX_CUSTOM_AUTH.GET_USERNAME)
loop
htp.p(' with this roles :: '||rec.role_list||'
');
end loop;
end;
----
Welchen Wert haben meine Page Items geraden:
select page_name
, page_id
, item_name
, display_as
, component_comment
, apex_util.get_session_state(item_name) session_value
from apex_application_page_items
where application_id = :APP_ID
and page_id = :APP_PAGE_ID
order by page_id,page_name
----
Informationen über meine Session:
begin
htp.p('');
htp.p('');
htp.p('');
htp.p('APP_USER');
htp.p(' ');
htp.p('');
htp.p(SYS_CONTEXT('APEX$SESSION','APP_USER'));
htp.p(' ');
htp.p(' ');
---
htp.p('');
htp.p('');
htp.p('APP_SESSION');
htp.p(' ');
htp.p('');
htp.p(SYS_CONTEXT('APEX$SESSION','APP_SESSION'));
htp.p(' ');
htp.p(' ');
---
htp.p('');
htp.p('');
htp.p('WORKSPACE_ID');
htp.p(' ');
htp.p('');
htp.p(SYS_CONTEXT('APEX$SESSION','WORKSPACE_ID'));
htp.p(' ');
htp.p(' ');
---
htp.p('
');
---
htp.p('
');
htp.p('');
htp.p('Request='||v('REQUEST'));
htp.p('
');
----
htp.p('
');
htp.p('');
FOR i IN 1..APEX_APPLICATION.G_F01.COUNT LOOP
htp.p('element '||I||' has a value of '||APEX_APPLICATION.G_F01(i));
END LOOP;
htp.p('
');
htp.p('
');
----
end;