Thursday, October 14, 2010

Removing Bulk User from Groups ---shared services v 11.1.x.x

1.login into shared services
go to the group from from which you want to remove .Double click the groups and you see a window pop up got to the USER MEMBER from there you can remove it manually.
2.if you want to users from many groups ,you can also do this
login into that shared services
go to FOundation Application group->click sharedservices->drop down native directory ->Right click on Groups and select export for edit.THat will save you Groups.csv file.
1,open that file
2.go to the group ,from which you want to remove the users (ctrl +F) .DO remove all the unwanted users.
3.remove the users entry under that group (whole row)and save it to the same file..
4go to FOundation Application group->click sharedservices->drop down native directory ->Right click on Groups and select IMPORT for edit.

thats all

or
3.you can maxl to do this
http://download.oracle.com/docs/cd/E12032_01/doc/epm.921/html_techref/maxl/ddl/statements/altusr.htm

No comments: