Andy Galbraith has a new permissions script:
I recently was tasked with this ticket:
Please add new login Domain\Bob to server MyServer. Grant the login the same permissions as Domain\Mary.
On the face of it, this seems relatively straightforward, right? It is the kind of request that we all get from time to time, whether as an ad-hoc task or as part of a larger project, such as a migration.
The catch of course is that it isn’t that easy – how do you know what permissions Mary has?
Andy’s script looks good. For bonus points, compare it to fn_my_permissions.