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!
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')
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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'll have a look at it, thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 Search
5. Click on the Name
6. Groups should be shown in the list
Edit: This is just for the groups, that the user belongs to
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.