Home Forums SQL Server 2008 SQL Server Newbies The SELECT permission was denied on the object 'abc', database 'xyz', schema 'dbo' RE: The SELECT permission was denied on the object 'abc', database 'xyz', schema 'dbo'

  • August 23, 2017 at 7:10 pm

    #1956531

    this command is the part that determines all the AD groups an AD user has database access through:
    EXEC xp_logininfo N'DomainName\UserName','all';