Which Table

[Former Member]

Hi All,

Can anybody here tell me where exactly the portal user details are getting stored?. Do Portal have its own database?. Where the user mapping details, role-based contents and stuffs like that are stored?.Is it in the database server where we install the SAP Web AS and create a J2EE schema?. If so what is the table name?.

Prompt replies would be rewarded.

Thanks in advance.

Regards,

Saravanan.

[Former Member]

Hi Saravanan,

the information about the roles is probably stored somewhere in the tables beginning with "EP_". Because

a role is a portal object you have at least one entry in the table EP_OBJECTS (field NAME contains the ID string

of the role, e.g. "com.sap.portal.eu_role").

For users I would search in the tables beginning with "UME_", but as there may be several user stores and

some caching mechanism in between I would not expect to get useful information from there.

It's anyway better to access the UME over the API (http://media.sdn.sap.com/html/submitted_docs/60_sp2_javadocs/ume/index.html).

Best regards,

Kilian

[Former Member]

Hi Sujesh,

Thank you very much for your reply. i have one more doubt. what will be in PCD (Portal content Directry )?. you said MAXDB is having the all details about user, could you please tell me what is the Database table name?. if it SQL-Server what is the table name? is there any naming convensions?.

Regards,

Saravanan.

[Former Member]

yes. user details, roles etc are stored in the maxdb which gets installed when we install netweaver portal. We can also configure the portal to use authentication for users stored in another LDAP server