To know all user id who did changes to a query.

[Former Member]

Hi all,

I have queries and structres in Production, and there are many users using the queries and strcutres and making changes to queries and structures. The end user are trained to become power users. So I want to know the all the user ids who made the changes to queries or structures since created. If I go to properties I can know only the last changed user id and owner of the query or strucure.

Any help is greatly appreciated

Thanks,

Raj.

[Former Member]

Allowing users to make query changes in production is dangerous. I would suggest changing the object changeability feature for Querys in the Transport Connection.

My suggestion would be to make that setting 'Changeable Original' so that users could create new queries and change their new queries, but not affect the queries transported into production.