microsoft/power-platform-skills / plugins/power-pages/skills/audit-permissions
audit-permissions
VerifiedAudits existing table permissions on a Power Pages site by analyzing them against site code and Dataverse metadata, then GRADES the configuration with deterministic 1–5 scores across 3 security/usability/correctness categories (9 dimensions). Detection is anchored by a recurring-issue catalog so findings and severities stay consistent run-to-run. Generates an HTML report with an at-a-glance verdict and per-category scores in the Overview plus a single list of **major/minor** issues (each major issue labelled permissions-only or upstream-caused with a short justification), and suggested fixes. Use when the user wants to review, verify, check, score, or grade table permissions for security issues. Supports SPA and PAC-downloaded non-SPA sites.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 77.5 KB |
| assets/audit-report.html | other | 27.8 KB |
| references/non-spa-site-workflow.md | markdown | 15.5 KB |
| scripts/collect-non-spa-permission-evidence.js | script | 16.2 KB |
| scripts/query-table-lookups.js | script | 1.9 KB |
| scripts/query-table-relationships.js | script | 1.7 KB |
| scripts/validate-audit.js | script | 3.3 KB |
scripts/query-table-lookups.js
View on GitHub#!/usr/bin/env node
// Queries Dataverse for lookup columns on a given table.
// Returns JSON array of { logicalName, targets } for each lookup column.
//
// Usage:
// node query-table-lookups.js --envUrl <url> --table <logical_name>
//
// Output (stdout): JSON array
// [{ "logicalName": "cr4fc_categoryid", "targets": ["cr4fc_category"] }]
//
// Exit codes:
// 0 = success (JSON on stdout)
// 1 = error (message on stderr)
const { getAuthToken, makeRequest } = require('../../../scripts/lib/validation-helpers');
const args = process.argv.slice(2);
function getArg(name) {
const idx = args.indexOf('--' + name);
return idx !== -1 && idx + 1 < args.length ? args[idx + 1] : null;
}
const envUrl = getArg('envUrl');
const table = getArg('table');
if (!envUrl || !table) {
process.stderr.write('Usage: node query-table-lookups.js --envUrl <url> --table <logical_name>\n');
process.exit(1);
}
(async () => {
const token = getAuthToken(envUrl);
if (!token) {
process.stderr.write('Failed to get auth token. Run: az login --allow-no-subscriptions\n');
process.exit(1);
}
try {
const result = await makeRequest({
url: `${envUrl}/api/data/v9.2/EntityDefinitions(LogicalName='${table}')/Attributes/Microsoft.Dynamics.CRM.LookupAttributeMetadata?$select=LogicalName,Targets`,
headers: {
Authorization: `Bearer ${token}`,
Accept: 'application/json',
},
timeout: 15000,
});
if (result.error || result.statusCode !== 200) {
process.stderr.write(`API error (${result.statusCode}): ${result.error || result.body}\n`);
process.exit(1);
}
const parsed = JSON.parse(result.body);
const lookups = (parsed.value || []).map(attr => ({
logicalName: attr.LogicalName,
targets: attr.Targets || [],
}));
process.stdout.write(JSON.stringify(lookups, null, 2) + '\n');
} catch (err) {
process.stderr.write(`Request failed: ${err.message}\n`);
process.exit(1);
}
})();
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit. | Stars: 471k | Updated | Claude CodeCodex | Verified | Install |
| rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure. | Stars: 471k | Updated | Claude CodeCodex | Verified | Install |
| rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics. | Stars: 471k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |