Not only on the user basis, but also via the groups the user belongs to. And if possible, which rights he has on the particular spaces.
Is this a query on the database? If so, can someone give me the SQL to be executed?
Thanks!
You can just do it in Confluence. 1.Click on the Confluence-Administration Button 2. User Management 3. Type in the name of the user 4. Click Search5. Click on the Name6. Groups should be shown in the listEdit: This is just for the groups, that the user belongs to
Fynn, then I know to which groups the user belongs, but not to which spaces the user has access, and which rights he has on these spaces.
This doesn't answer all of your question, but, it is a good way to see and manage overall permissions across your site - getSpacePermissionList. This is part of Confluence Command Line Interface (CLI).
I'll have a look at it, thanks.
SQL queries for you:
SELECT spacename, permtype, permgroupname from spacepermissions join spaces on spaces.spaceid = spacepermissions.spaceid where permgroupname = 'GROUP_NAME'
select spacename, permtype, lower_username from spacepermissions join spaces on spaces.spaceid = spacepermissions.spaceid join user_mapping on spacepermissions.permusername = user_mapping.user_key where lower_username = 'jdoe'
And the honker that you're looking for (username is the only value you need to update and it's on the bottom line for your convenience - note that there are two places on that line you need to update it):
SELECT spacename, permtype, permgroupname, lower_username from spacepermissions LEFT JOIN spaces on spaces.spaceid = spacepermissions.spaceid LEFT JOIN user_mapping on spacepermissions.permusername = user_mapping.user_key where (permgroupname IN (select GROUP_NAME from cwd_user u, cwd_group g, cwd_membership m where m.child_user_id = u.id AND m.parent_id = g.id AND lower_user_name = 'jdoe') OR user_mapping.lower_username = 'jdoe')
It looks like you're new here. Sign in or register to get started.
