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.
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 :-)