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'
coolchaitu
SSChampion
Points: 10332
More actions
August 23, 2017 at 9:13 pm
#1956541
Chris Harshman - Wednesday, August 23, 2017 8:00 PMEXEC xp_logininfo N'NTLAB\E15770','all';this should do that. the user specified doesn't need to be directly created as a login or user in SQL Server, just have some access through an AD grouphttps://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/xp-logininfo-transact-sql
EXEC xp_logininfo N'NTLAB\E15770','all';
Hi Chris,It is not returning any result. Could you please advise