on 05-12-2006 1:59 PM
Hi!
I would like to know , is there way that we can get a report which shows all the portal user ids with there assign portal roles. If we can't get this from portal. Can we get it from Oracle database ?
What are the oracle tables and fields which store this information?
If nay one have a custom develop iview for this please let me know
Thanks
Ramesh
Hi Ramesh,
go to User Administration -> Import / Export -> User Data Export and select ALL_USERS. You'll get al list of all user IDS and their roles. You can then import it to Excel or whatever you want.
Regards,
Pascal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ramesh,
then I'm pretty sure you can't get around programming something, please see https://media.sdn.sap.com/javadocs/NW04/SPS15/um/index.html for the UME Api, if you have experience in programming Java it should be straightforward.
Regards,
Pascal
Hi Ramesh,
additionally to the export, you can also write some small report program using the UME API, which is very intuitive and easy to use. With this, you could define the format of the output by yourself (as XML for example).
Hope it helps
Detlev
PS: Please consider rewarding points for helpful answers on SDN. Thanks in advance!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
i Ramesh,
There is no report which gives u directly this kind of portalusers listing with their roles.
U can go to USER ADMINISTRATION->import/export-> User Data Export and select all users.
download it. copy it to excel sheet adn format according to ur needs.
The same is used in the conetxt of mass uploading users data into the protal . i,e create or change portal users in one shot.
Thanks & Regards
Jhansi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.