Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How to remove a user from all the ibots they are subscribed to in obiee 10g?
Obiee_Developer1
Rank 2 - Community Beginner
Every time when an employee quits we have to remove him/her from the ibots they are subscibed to. I would like to know if there is table in database that will allow me to remove them all at once. I also want to know what sql script or steps I need to take? Instead of removing a user from going into each ibot and it's subscribers, I would like to remove them all at once. Thanks!
0
Answers
-
Did you check with sa_system table. delete the user name from sa_system table in db. It will remove from all the ibots..
0