We recently had to work out a way to fetch and display all effective permissions granted to our Production SQL Server. I had been required…