Change Access Status

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

This action builds and submits a basic ALTER TABLE... READ ONLY/READ WRITE statement. This lets you toggle the table between READ ONLY and READ/WRITE modes.

Note: In DBArtisan, the Datasource Explorer listing for an Oracle table has a Read-Only field that displays the current mode for a table.

Platform Availability

To Change Between READ ONLY and READ WRITE Modes for a Table

  1. Initiate a Change Access Status action against one or more tables. For more information, see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying settings in the dialog:
Step Settings and tasks

Action options

Select the Read-only check box to generate a ALTER TABLE... READ ONLY statement, putting the table into read-only mode. Deselect the Read-only check box to generate a ALTER TABLE... READ WRITE statement, putting the table into read-write mode.


Lets you review the objects potentially impacted by this action. For more information, see Dependencies.


Preview the DDL generated for the operation. For more information, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.