nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

User/Group Space Permissions

Hossam Khalil

Hi There,

As in JIRA, where ou can see all of a user's Project permissions, is it possible to list all the permissions, those of a certain user on all confluence spaces, using SQL and Postgres..?

Confluence Version:

5.10.8

Thanks

Hossam

Accepted answers

Igor M_

Hello,

You can use DB queries described in How to list which spaces a user can access KB.

Let me know if you have questions

Regards,

Igor

All comments

Igor M_

Hello,

You can use DB queries described in How to list which spaces a user can access KB.

Let me know if you have questions

Regards,

Igor

Hossam Khalil

Thanks Igor,

That seems like the right solution for this, if the Environment was installed perhaps on a greenfield Environment, with Standard Installation.

however, in our case, that is not plausible.

if any possibility to run CLI for confluence, i would have to either search in the backend Postgres DB Servers, or maybe install the CLI plugin for confluence, and that is another Story.

but for now, your solution Looks good, thanks

hossam

Igor M_

Alternatively, you can try to create a User Macro to pull such information as discussed in this community thread: https://community.atlassian.com/t5/Confluence-questions/list-group-permissions-on-spaces/qaq-p/376395

Regards

Igor

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server