how to know the permissions available to a window groups in sql server

• Saurabh Aggarwal

  Ten Centuries

  Points: 1073

  More actions

  July 21, 2009 at 5:52 am

  #212343

  how to know the permissions available to a user belong to a window groups in sql server database.

  And also how to know the window group of a user belongs too in sql server.

  Will appreciate the replys

• Sanz

  Hall of Fame

  Points: 3412

  More actions

  July 21, 2009 at 6:42 am

  #1027566

  Use the following script to know about the Windows Group in SQL Server

  DECLARE @LoginName sysname

  DECLARE @sql NVARCHAR (2000)

  BEGIN

  DECLARE cur_Loginfetch CURSOR FOR

  SELECT [name] FROM master.sys.server_principals WHERE TYPE = 'G'

  OPEN cur_Loginfetch

  FETCH NEXT FROM cur_Loginfetch INTO @LoginName

  WHILE @@FETCH_STATUS = 0

  BEGIN

  EXEC xp_logininfo @LoginName , 'members'

  FETCH NEXT FROM cur_Loginfetch INTO @LoginName

  END

  CLOSE cur_Loginfetch

  DEALLOCATE cur_Loginfetch

  RETURN

  END

  Sanz

• Saurabh Aggarwal

  Ten Centuries

  Points: 1073

  More actions

  July 21, 2009 at 6:04 pm

  #1028035

  Thanks a lot for your help, it solve my prob;