Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX22: Copy All Application Users & Roles to another environment

User_IDKQUSep 11 2023 — edited Sep 11 2023

Hi All,

Please bear with me as I have never used the in built user / role in an APEX application before always had custom authentication.

Whenever we deploy the full application to our UAT environment we lose all our test users, creating all the users & roles again is a painful process to do manually as there are a fair few of them - is there an easy way to do this?

Ideally what we would like to do is to copy the PROD users & associated roles into our UAT environment using a script.

Any help would be appreciated :)

Cheers

Comments
Post Details
Added on Sep 11 2023
3 comments
148 views