Hi. I am using authorization scheme. The name of the authorization scheme is 'IS_MANAGER'.The Scheme type is 'PL/SQL function returning Boolean'.
The PL/SQL Function body is:
begin
if :APP_USER='DAVID' or :APP_USER='MORGAN'
then
return true;
else
return false;
end if;
end;
Identify error message displayed when
scheme violated (Value Required):Not a manager.
Validate authorization scheme:Once per session.
I have an interactive report. In one of the columns I am displaying a button.I should display this button only for managers (i.e only for 'DAVID' and 'MORGAN').
I have this CASE condition in the interactive report query.
CASE WHEN :APP_USER IN (/*Managers*/ 'DAVID','MORGAN')
THEN '<button type="button" class="button-default" >
<span>Reroute</span></button>' END
Now I have to replace these hardcoded values condition with the authorization scheme. I have tried different combinations but did not work out.Can some one please help me?