Get logins, databases users/roles and object level permission (T-SQL)

Introduction

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.

Scenarios

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

https://gallery.technet.microsoft.com/scriptcenter/Get-logins-databases-816f66b2

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s