All Users and Groups Summary (Admin Included)
Complete Export with Admin
- Source:
C:\Users\david\Downloads\auth_backup_20260316_021641.db - Export Date: 2026-03-16T03:26:12.0962439Z
- Output File:
all_users_and_groups.json - Format: Complete JSON (all users including admin, PINs set to 9999)
📊 Complete Data Summary
👥 All Users (6 total)
| Name | ID | Roles | PIN | Groups | Chat Access | |——|—-|——-|—–|——–|————-| | Admin | 1 | Admin,Player | 9999 | (none) | ✅ Admin access | | Alice | 5 | Player | 9999 | Ted-Alice | ✅ Group member | | Bob | 2 | Player | 9999 | Bob-Carol | ✅ Group member | | Carol | 3 | Player | 9999 | Bob-Carol | ✅ Group member | | Fred | 6 | Player | 9999 | (none) | ❌ No groups | | Tad | 4 | Player | 9999 | Ted-Alice | ✅ Group member |
🏷️ Groups (2 total)
| Name | ID | Owner | Members | Description | |——|—-|——-|———|————-| | Bob-Carol | 1 | Bob (2) | Bob, Carol | Bob and Carol’s group | | Ted-Alice | 2 | Alice (5) | Alice, Tad | Ted and Alice’s group |
📋 JSON Structure
{
"exportDate": "2026-03-16T03:26:12.0962439Z",
"users": [
{
"id": 1,
"name": "Admin",
"roles": "Admin,Player",
"pin": "9999",
"groups": []
},
{
"id": 2,
"name": "Bob",
"roles": "Player",
"pin": "9999",
"groups": ["Bob-Carol"]
}
],
"groups": [
{
"id": 1,
"name": "Bob-Carol",
"description": "Bob and Carol's group",
"ownerId": 2,
"members": ["Bob", "Carol"]
}
]
}
🔍 Key Features
Universal PIN Access:
- All users have PIN set to “9999” for easy testing
- Admin included with full Admin,Player roles
- Consistent authentication across all accounts
Complete User Coverage:
- Admin user - Full system access
- 5 regular players - Various group memberships
- Isolated user - Fred for testing access denial
Group Structure:
- Bob-Carol - 2 members (Bob owner, Carol member)
- Ted-Alice - 2 members (Alice owner, Tad member)
- Admin - No group membership (admin override access)
🎯 Use Cases
Development Testing:
- Full user access - All accounts use same PIN
- Admin functionality - Test admin features
- Group isolation - Verify proper filtering
- Access control - Test Fred’s isolation
Documentation:
- Complete user roster - All system accounts
- Login credentials - Universal PIN for convenience
- Group relationships - Full mapping
- Role permissions - Admin vs Player roles
Configuration Reference:
- Seeding template - For new databases
- User management - Account structure
- Group management - Ownership and membership
- Security testing - Access patterns
🔐 Security Notes
PIN Standardization:
- All PINs set to 9999 - For testing convenience
- Not for production - Change PINs in live environment
- Admin access - Full system privileges
- Player roles - Limited to group access
Access Patterns:
- Admin - Can access all groups and features
- Group members - Limited to their groups
- Non-members - No chat access (Fred)
- Owners - Additional group management rights
📁 File Information
- Location:
all_users_and_groups.json - Size: Complete user and group data
- Security: Contains login credentials (PINs)
- Format: Clean, readable JSON
✅ Verification Checklist
Data Completeness:
- All 6 users included (admin + 5 players)
- All 2 groups included
- All PINs set to 9999
- All group memberships mapped
User Access Matrix:
- Admin: Full system access ✓
- Alice: Ted-Alice group only ✓
- Bob: Bob-Carol group only ✓
- Carol: Bob-Carol group only ✓
- Fred: No groups (isolated) ✓
- Tad: Ted-Alice group only ✓
Group Structure:
- Bob owns Bob-Carol group ✓
- Alice owns Ted-Alice group ✓
- Proper member assignments ✓
- Admin has no group membership ✓
🚀 Perfect for Testing
This complete JSON provides:
- Universal login access with PIN 9999
- Full user coverage including admin
- Complete group relationships
- Easy testing credentials for all scenarios
Status: ✅ COMPLETE
Complete users and groups export created successfully, including Admin user with all PINs standardized to 9999 for easy testing and development access.
