Enhancing efficiency through centralized system for site permissions in Infrastructure
Centralized SharePoint site permissions management solution.
Context
Company has multiple SharePoint sites with varying permissions, making it challenging to manage and monitor access rights across all
There was a need for a centralized system to efficiently view and manage site permissions, active groups, and associated members.
Existing permissions management processes were manual and time- consuming, lacking a unified view for administrators.
Challenges
Lack of a consolidated view of permissions and user groups across multiple SharePoint sites.
Time-consuming manual processes for extracting and reviewing site permissions.
Difficulty in tracking changes in site access and ensuring compliance with organizational policies.
Need for a secure and user-friendly interface for administrators to view and manage permissions.
Solution
Automated permissions extraction: Created PowerShell scripts to extract site permissions and active user group details using administrator credentials.
Centralized management interface: Developed a master screen in Microsoft PowerApps to display and manage permissions data in real-time.
Data consolidation and reporting: Automated data import to PowerApps for easy monitoring and management.
