How to Find Users and their AD groups in SQL Server - SQL Server DBA

How to Find Users and their AD groups in SQL Server - SQL Server DBA

As a SQL Server DBA, managing user access and permissions is crucial. Often, users belong to Active Directory (AD) groups that grant them access to the SQL Server instance. Knowing which users belong to which groups helps you effectively manage security and identify potential access issues.


1. Finding Members of an Active Directory Group:

Copied!
exec master.dbo.xp_logininfo 'DBAScrolls\sqldba', 'members'  


2. Finding out Active directory group that user belong to:

Copied!
exec master.dbo.xp_logininfo 'DBAScrolls\sqldba'
Lince Sebastian

Indian MSSQL DBA thriving in database management - ensuring efficiency and smooth operations. Devoted father of two and avid Clash of Clans player, driven by strategic thinking. Football fuels my passion - cheering Kerala Blasters and Arsenal. I share my professional and life insights through my blog.

*

إرسال تعليق (0)
أحدث أقدم