Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 293 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 116 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to delete the users folders in the Catalog/System/Security/Users folder
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
Answers
-
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.
0