[Script of May 10] Get logins, databases users/roles and object level permission (T-SQL)
Script Download: LoginUserRolePermission.zip
https://gallery.technet.microsoft.com/scriptcenter/Get-logins-databases-816f66b2/
This script contains three code parts, one to get the result of server level logins and related roles, one to get the result of user databases’ users and related roles, one to get the result of object level permission of specific database.
This script can be used to get the following results:
- Server level logins and related roles
- User databases users and related roles
- Object level permission of specific database
Â
 |
 |
|
 |
 |
|
You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery