How to delete the users folders in the Catalog/System/Security/Users folder

user13266902

We recently migrated to 11.1.1.7.XXX version and we have manually deleted the users from the catalog and migrated. In that process we see a lot of users files also in the path Catalog/System/Security/Users folder, but we don't want to delete them manually because as it would raise any other permissions/ security issues. We tried validating the catalog with the assumption that the users who did not login in to the system will be termed as invalid and the corresponding users files will be deleted. but it did not happened so. Just want to check if there is any best way that we can clean up this automatically without any impact to catalog permissions/ security

Regards,

Sri

[Deleted User]

I wrote about that a while ago and put a rather hacky script online here: http://hekatonkheires.blogspot.ch/2014/03/purging-corrupted-obiee-web-catalog.html

Never gotten round to productizing it or make it dynamically loop through a list of users but you can easily adjust it.