Preventing ALTER TABLE

To prevent anyone else from altering a table which you are modifying in CA Datacom Datadictionary, do one of the following:

If SQL security is implemented for the database containing the tables, issue the following SQL command:
```
REVOKE ALTER ON table-name FROM PUBLIC
```
This prevents anyone from issuing an ALTER TABLE against the named table (or tables). After you have made your changes in CA Datacom Datadictionary and copied the table back to PROD status, you must GRANT ALTER to each accessor-ID individually.
Instead of using SQL security, you can:
1. Use online or batch CA Datacom Datadictionary to assign a password to the PROD status version of any TABLE entity-occurrence which you intend to modify. (The password prevents anyone from performing an SQL ALTER TABLE on a table.)
2. Restore the structure containing the tables you want to modify from PROD status to a TEST status version.
3. Use CA Datacom Datadictionary to make the modifications you need to make to the TEST status version of these TABLE entity-occurrences.
4. Copy these TABLE entity-occurrences to PROD status.
5. Use online or batch CA Datacom Datadictionary to remove the passwords you assigned in Step 1.