Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2009
    Posts
    2

    Unanswered: SQL Server: How do I determine the security group through which a user is granted per

    In SQL Server, a user in my domain is able to access a database because they are a member of a particular security group. How can I determine the security group that this user is a member of and therefore is gaining access?

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Take a look at MSSQL Server security catalog views:
    Security Catalog Views (Transact-SQL)
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    exec master.dbo.xp_logininfo '<domain\account>', 'all'
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  4. #4
    Join Date
    Aug 2009
    Posts
    2
    Quote Originally Posted by rdjabarov
    exec master.dbo.xp_logininfo '<domain\account>', 'all'
    Thank you, that all I need

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •