01-12-2012 11:36 AM
Hi all,
In our production system, Users are reporting saying the query assignment done through (SQ03) has disappeared, that is when users were created (long back in 2006) queries were also assigned, but all of a sudden the assignments are deleted. We as a Security team have not removed this, So Please let me know if there is a way to trace these changes.
Regards
Sushma
01-12-2012 12:06 PM
Hi,
Query assignment is not done through SQ03, adhoc query user groups are assigned to users using SQ03. Is that all user groups were deleted from the system?
Thanks,
Deb
01-12-2012 12:13 PM
Query assignment done through SQ03, which users see through Sq01 is deleted, queries are not deleted, but some users have lost access to queries as the query assignment is deleted.
we have temporarly fixed this by reassigning, but what to know the route cause to avoid this in future.
Regards,
Sushma
01-12-2012 1:15 PM
I have seen this happen before when transports of the groups came through which deleted them. Sometimes in the wrong sequence.
However they can also be deleted in the target system and there is no (default) logging of it.
Are there any short-dumps? Anything in the transport logs from when this started?
Cheers,
Julius
01-12-2012 1:34 PM
Hi Julius,
We do not have any short dumps, please let me know transport log of which component I need to check, we didn't have any security transports moving, but users reported that they lost access, if you advice what kind of transports effect I can go back check with basis team on that.
Thanks a lot for your time
Regards,
Sushma
01-13-2012 1:40 PM
Hi
I did speak to dev team, seems they do not transport the modifications to these queries instead they upload the changes, and we do see changes done a day before the query user assignment disappeared. Is there any way I can prove that this was the cause
Please advice
Regards,
Sushma
01-13-2012 9:05 AM
Hi All,
Please advice if we need to look into any specific transport logs or if there are any relavent Notes whichc will help me.
Thanks in advance
Sushma