Confluence space permission check

[Anderson Hsu]

Dear all, 

How to use sql command to list page list by it's permission and space in postgresql ? Thanks a lot.

[Kiran Panduga {Appfire} · Accepted solution]

Hi @Anderson Hsu , 

I hope the below article will help you to check the space permission through SQL queries.

https://confluence.atlassian.com/confkb/how-to-check-permissions-for-a-space-via-sql-queries-717062216.html

Thanks,

Kiran.

[Kiran Panduga {Appfire}]

Hi @Anderson Hsu , 

This plugin SQL for Confluence (Pro Edition) might be interesting to you. It displays results from a SQL query. Data from one or more result sets are formatted and typically displayed as a table. This enables dynamic data to be easily displayed on pages together with documentation and other data. Integrate business intelligence reports with your other collaborative data.Supports JDBC complaint databases, like MSSQL, Oracle, DB2, PostgreSQL, MySQL.
https://marketplace.atlassian.com/plugins/org.swift.confluence.sql/server/reviews 

Thanks,

Kiran.

[Anderson Hsu]

Dear Kiran, 

I know the plugin appliction, but is there sql command for the example. 

Best Regards, Anderson Hsu