Hamid62
Hamid62

Reputation: 183

How to get all Users and Roles information from Liferay in other applications?

I am developing a C# program and I need to show Users and Roles list in it from Liferay database.
Is there any service to fetch these information for me?

Upvotes: 3

Views: 2150

Answers (1)

Jonny
Jonny

Reputation: 2683

You should check out the Liferay JSON Web Services to get this kind of information (without having to query the DB directly).

If you go to http://your-liferay-server-url.com/api/jsonws you can see all the Web Service end points that Liferay provides, and that you can make calls to.

If you however want to directly query the Liferay database then look at the following tables:

  • groups_roles
  • groups
  • role_
  • user_
  • users_roles
  • usergrouprole

That should be all of the tables in the DB that you need to get the info, and you may not even need all of those tables for what you need.

Upvotes: 1

Related Questions