Implement basic audit columns in gallery data connections

[TheCoffeeDude]

The gallery needs to implement basic auditing in the data connections.Currently, there is no way to determine who or when a data connection was created or updated.

The dataConnections Collection contains data connections with these keys

• _id: (ObjectId) Document primary key.

• ConectionString: (String) Hashed database connection string.

• PasswordSecured: (String) Encrypted password for the database connection.

• ConnectionName: (String) Data connection display name.

• Subscriptions: (Array) Array of subscription IDs the data connection has been shared with.

• Users: (Array) Array of user IDs the data connection has been shared with.

• UserGroups: (Array) Array of group IDs the data connection has been shared with.

Add these keys to provide a basic audit trail

• CreationDate: (DateTime) Date time in UTC when the data connection was created.
• CreatedByUser: (String) user ID of the user that created the data connection.
• LastUpdateDate: (DateTime) Date time in UTC when the data connection was updated.
• UpdatedByUser: (String) user ID of the user that updated the data connection.

Modify the gallery to allow the values of the new keys to be displayed. Modify the API endpoint to retrieve this information.