Managing groups in Confluence v4.1.2.

kim jungmin

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.

I am looking forward to hearing your answer.

RianA

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.