Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

GA ANNOUNCEMENT - Change ADB Mode to Read/Write or Read-Only

edited Jan 27, 2022 12:23AM in Autonomous Database

Content

It is now possible to select an Autonomous Database operation mode - the default mode is Read/Write. If you select Read-Only mode users can only run queries.

In addition, for both modes it is possible to restrict access to only allow users with the RESTRICTED SESSION privilege to connect to the database. The ADMIN user has this privilege.

A typical use case for restricted access mode is to allow for administrative tasks such as indexing, data loads, or other planned activities.

For more information see here:

DOC: Change Autonomous Database Mode to Read/Write or Read-Only for ADW,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!