T Today, I will show you how to easily check if your authorization schemes set on pages match the schemes set in the navigation. In my custom navigation (including the multicolumn navigation ), I don't have to set it in two places (which is never a good idea). My navigation gets the schemes from the pages. But the default APEX navigation is not like that. That causes a lot of confusion to users when they see a page in navigation, but can't access it. Or when they have some hidden pages, and they are missing the navigation links. Fortunately, if you combine few APEX views, you can find out: SELECT p.application_id, e.list_name, p.page_id, p.page_name, --p.page_alias, --p.page_group, --p.page_mode, p.authorization_scheme AS auth_scheme_page, e.authorization_scheme AS auth_scheme_nav, e.entry_text, e.entry_target -- FROM apex_application_pages p LEFT JOIN apex_application_lists l ON l.application_id = p.application_
I I spent the past few days at the HrOUG conference in Rovinj, on the Red Island. I was there for the first time. The location was superb, but difficult to get to, at least from Prague. No direct flights, no trains, 9 hours by car... The hotel was ok, I expected it would be a bit outdated and it was not. But I was not expecting a noise till 2am. If you are not an old fart who goes to bed at 10pm like me, you probably won't bother. The food was excellent. I don't think this can be improved. The sessions. With the 5 tracks and one dedicated to Oracle APEX and the other one to Oracle AI , there was always something interesting to listen. Just check the agenda link at the top. These conferences are really a great opportunity how to stay ahead of the people who don't go there. As a speaker, you can pass your knowledge to others. Very different experience than online events. The people. Probably the best part of the whole conference. You meet a lot of cool people. A