👥 Permissions Manager
User and role permission analysis across all databases
156
Total Users
24
Roles
8
Sysadmins
5
Orphaned
3
Issues
👤 High-Privilege Users
| User | Server | Role | Last Login |
|---|---|---|---|
| sa | PROD-SQL-01 | sysadmin | Disabled |
| dba_admin | All Servers | sysadmin | 2 hours ago |
| app_owner | PROD-SQL-01 | db_owner | Active |
| backup_svc | All Servers | db_backupoperator | 1 hour ago |
| report_user | RPT-SQL-01 | db_datareader | 30 min ago |
⚠️ Permission Issues
🚨
Orphaned user: old_developer
PROD-SQL-02 • No matching login
PROD-SQL-02 • No matching login
⚠️
Excessive permissions: temp_user
PROD-SQL-01 • db_owner on production
PROD-SQL-01 • db_owner on production
⚠️
Stale account: contractor_2024
All Servers • No login in 90 days
All Servers • No login in 90 days
🔐 Role Membership Summary
| Role | Type | Members | Permissions | Servers |
|---|---|---|---|---|
| sysadmin | Server | 8 | ALL | All |
| db_owner | Database | 12 | DDLDMLGRANT | Production |
| db_datareader | Database | 45 | SELECT | All |
| db_datawriter | Database | 28 | INSERTUPDATEDELETE | Dev/Test |