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.