Add Audit fields to Instances to track User Actions
Currently we do not track any user level information in the instances table. In Nova we have the user_id for the user that created the instance. However, if the instance is deleted or modified, we do not record their ID. This is critical information for audit and compliance. The proposal is the for each action, to have a corresponding fields with the user id. Suggested field names are "created_by", "updated_by" and "deleted_by". These fields are immutable once set, with the exception of "updated_by" which will have only track the last update.
Whiteboard
once these fields are created the first and perhaps only hurdle will be is back filling the data. For created, we could pull data from nova. For updated_by, we could use created_by if updated_at == created_at. For deleted_by we only need to populate the data if deleted_at is not None. The value for this field would be difficult to determine.
