training

Implement a new permission for viewing catalog categories in the Reporting module.

Permission:
reporting.catalog.categories.view

Changes:

Add the reporting.catalog.categories.view permission to all existing tenant schemas.
Assign the permission to user_id = 1 and role_id = 1.
Assign it to company_admin and tenant_admin roles when present.
Do not grant this permission to other roles by default.
Update the Catalog Categories API to use the new permission instead of the broader ViewSupport permission.

API:
GET /categories

Update the permission attribute to:

[RequirePermission(SystemPermissions.ViewReportingCatalogCategories)]

Migration:
Create:

V0140_add_catalog_categories_report_permission.sql

The migration should safely create the permission only when it does not already exist and avoid duplicate user/role permission assignments.