Skip to Main Content
  • Questions

  • Oracle apex - changing page authorization scheme on custom form

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Hari.

Asked: May 12, 2021 - 6:48 pm UTC

Last updated: June 10, 2021 - 6:04 am UTC

Version: 19c autonomus database

Viewed 1000+ times

You Asked

Hi, is it possible to change page authorization scheme ( or another page properties) in oracle apex on some custom build form . I need it for my application admin panel . I know which table is it , it is apex_200200.wwv_flow_list_items but on cloud its forbidden to edit WWV prefixed tables of apex_200200 user. I tried to find API - package to do it but cant find it.

On cloud user ADMIN don't have select privilege on that table so this query is not working:

select * from apex_200200.wwv_list_items
[Error] Execution (1: 27): ORA-01031: insufficient privileges

I tried to use this package but I'm getting no results :
begin
WWV_FLOW_API.update_page(p_id=>124,p_flow_id=>122,p_required_role=>'7.59043067032354E15');
end;

Is there any way to do this through some other package in database.






and Connor said...

Well... I get this on my local APEX instance

SQL> select * from dba_objects
  2  where object_name = 'WWV_LIST_ITEMS';

no rows selected

SQL> select * from dba_objects
  2  where object_name like '%WWV_LIST_ITEM%';

no rows selected


so not entirely sure what you're after there, but maybe you want APEX_APPLICATION_LISTS and APEX_APPLICATION_LIST_ENTRIES

However, I do not know of an supported API that is going to let you modify an app dynamically like you're after.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Details about original post

Hari, June 08, 2021 - 7:19 pm UTC

Hi thx for response, actually my select is :

select * from  APEX_200200.WWV_FLOW_LIST_ITEMS

and got error:
Error] Execution (1: 27): ORA-01031: insufficient privileges

(Not APEX_200200.WWV_LIST_ITEMS my mistake).

As ADMIN user of my cloud database I do not have any rights on APEX_200200 tables and cant change password for APEX_200200 user.

On my on premise 11g database I do not have these problems and I have select and edit privileges on those tables .
Doing this, my users (only admin of application), can change authorization scheme of the pages (application list items) in the application through custom form without accessing shared components or Page edit board. Also there are many APIS for user control so I thought there is one for list items control.

I checked APEX_APPLICATION_LIST_ENTRIES view you suggested and it is good for reports and preview of all list items and their properties but I need to change some of these values.



Connor McDonald
June 10, 2021 - 6:04 am UTC

I will ask the internal APEX team, but if it is not in the docs, then even if there *was* an API you would not be supported.

I can assure you that editing WWV_... tables directly in the APEX schemas is definitely not supported :-)
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

APEX

Keep your APEX skills fresh by attending their regular Office Hours sessions.