How To: Get Advanced Roadmaps (formerly Portfolio) Plan and Program permissions information
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
サーバー*製品のサポートは 2024 年 2 月 15 日に終了しました。サーバー製品を利用している場合は、アトラシアンのサーバー製品のサポート終了のお知らせページにて移行オプションをご確認ください。
*Fisheye および Crucible は除く
要約
When using Jira and Advanced Roadmaps (formerly Portfolio), it is generally useful for administrators, to have a view of all the permissions of each user for each Plan or Program through the database.
環境
Applies to Jira Server installations with Advanced Roadmaps (formerly Portfolio).
ソリューション
Get Program owner's name
SELECT au.lower_user_name "Owner",
prog."ID" "Program_Id",
prog."TITLE" "Program_Title"
FROM "AO_D9132D_PROGRAM" AS prog
JOIN app_user AS au ON prog."OWNER"=au.user_key;
Get Plan owner's name
SELECT au.lower_user_name "Owner",
plan."ID" "Plan_Id",
plan."TITLE" "Plan_Title"
FROM "AO_D9132D_PLAN" AS plan
JOIN app_user AS au ON plan."CREATOR_ID"=au.user_key;
Get Program permissions information
SELECT au.lower_user_name "Username",
prog."TITLE" "Program_Title",
perm."HOLDER_TYPE",
perm."ID" "Permission_Id",
perm."PERMISSION" "Permission_Type",
perm."PROGRAM_ID" "Program_Id"
FROM "AO_D9132D_PERMISSIONS" AS perm
JOIN app_user AS au ON perm."HOLDER_KEY"=au.user_key
JOIN "AO_D9132D_PROGRAM" AS prog ON perm."PROGRAM_ID"=prog."ID";
Get Plan permissions information
SELECT au.lower_user_name "Username",
plan."TITLE" "Plan_Title",
perm."HOLDER_TYPE",
perm."ID" "Permission_Id",
perm."PERMISSION" "Permission_Type",
perm."PLAN_ID" "Plan_Id"
FROM "AO_D9132D_PERMISSIONS" AS perm
JOIN app_user AS au ON perm."HOLDER_KEY"=au.user_key
JOIN "AO_D9132D_PLAN" AS plan ON perm."PLAN_ID"=plan."ID";
最終更新日 2024 年 11 月 29 日
Powered by Confluence and Scroll Viewport.