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!

How to reset 'Restrict Access by IP Address' setting

MonkeyThinkJan 13 2020 — edited Jan 13 2020

Hi All,

I have an APEX workspace which has access to the management console restricted by IP address by setting the 'Restrict Access by IP Address'.  I haven't accessed it for some time now and I've changed office locations, so no longer have access to the restricted IP address.

I know there is a way to remove the restriction (with an update statement to remove the setting I believe) having logged in to the database with a privileged user account.  I've done it before, and I thought I'd emailed the details to myself last time I needed to do it so that I would have it for reference after a few hours of googling and searching old emails  I can't find it!

Can someone remind me how to do this please?

Regards
Adam

Comments
Post Details
Added on Jan 13 2020
1 comment
830 views