configure access ton several different databases from only one space with Play SQL on Confluence

[HN]

Hello,

I'm trying to configure access ton several different databases from only one space with Play SQL on Confluence.

Do you lnow if it's possible ? If yes, how ?

Thanks !

Play SQL version : 2.12.5 

Atlassian Confluence 6.1.3

[Radek Janata]

I've workarounded this by having separate "SQL" spaces for each datasource. Each such special space has limited number of admins who can define queries and users who can create pages using Play SQL macros. All other can read only predefined pages with queries.

Pages/tables from these dedicated SQL space are then included via Include page macro to any other regular spaces.

Another advantage is that you have separated regular space admins and datasource/SQL space admins.

These dedicated SQL space have their own naming convention (SQL prefixes, sql label) and, as I have already mentioned, different permissions setup.

[Dennis Winter]

+1