user_class_mapping
Purpose
This document outlines the purpose and structure for storing audit data of the Automate user(s) permissions changes detected by the client script Automate Users Permission Audit.
Dependencies
Automate Users Permission Audit.
Tables
user_class_mapping
| Column | Type | Explanation |
|---|---|---|
| userid | int | Automate User ID |
| username | varchar | Display name of the User |
| varchar | Email ID assigned to the Automate user | |
| user_permissions | varchar | This stores the Client-level permissions of the Automate User |
| secondary | varchar | This stores the Group-level permissions of the Automate User |
| classid | varchar | User Class ID |
| classname | varchar | Stores the User Class name assigned to the Automate user |
| class_permissions | varchar | Stores the User Class permissions |
| permissionshigh | varchar | Stores the User Class plugins permissions |
Changelog
2025-10-07
- Initial version of the document