Could someone please tell me in which table confluence stores its user details?

Question

I want to know how many users are having permission to access confluence. which table to refer?

LuizA · Answer

Hello Sultan,

If you want to check information about your users (and know how many users have access to your instance) you can try to check the table 'cwd_user' in the database for more recent Confluence versions (in this table you have the information related with your users and you can see which one is active or not also). I hope this helps.

Cheers,

LJ.

Matthew J. Horn · Answer

Are you referring to which database table in the confluence data model? The user table refences local_members, which has the group ID. User permissions are typically tied to group IDs, so that would be where I would start.

danielwester · Answer

Not sure about the table but why not just look at your license page?

https://confluence.atlassian.com/display/DOC/Viewing+and+Editing+License+Details