Hi Christian, thanks for the interesting informat...

2011-12-07T20:31:25.520+01:00

Hi Christian,

thanks for the interesting information.

Tobias

Hi Tobias! One thing that might not be obvious wh...

2011-12-06T11:26:08.961+01:00

Hi Tobias!

One thing that might not be obvious when using our authorization checking function in SQL or PL/SQL is that caching still takes place. The authorization will only be evaluated at most once ("Once per page view") or not at all, if it's result is already stored in session state.

If you are using the function in SQL, a non-optimal execution plan might still cause many context switches to PL/SQL. In that case, you could use scalar subqueries, e.g.

select
'VALID_USER' as return_val
from my_table
where col1 = 'NEW'
and ( (select my_check_auth('AUTH_VALID_USER') from dual)=1
or (select my_check_auth('AUTH_NEW_USER') from dual)=1 );

Regards,
Christian

Comments on APEX-AT-WORK by Tobias Arnhold: Advanced ways using the Authorization Schemes insi...

Hi Christian, thanks for the interesting informat...

Hi Tobias! One thing that might not be obvious wh...