I am a manager of the confluence(v4.1.2) in our company.
Since there are lots of members and groups, it is difficult to manage them.
So I am wondering that there is any way to find out spaces or pages which a certain group is used for a access permission in group management menu.
You could achieve this from the SQL query.
SELECT s.SPACENAME, sp.PERMGROUPNAME, sp.PERMUSERNAME FROM SPACEPERMISSIONS sp JOIN SPACES s ON sp.SPACEID = s.SPACEID WHERE PERMTYPE = 'VIEWSPACE';
Hope it helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.