May 12, 2020 at 5:21 pm
Hi everyone. Does anyone know how i can populate the permission path for the query below? It used to have an account, and now it no longer does. It returns null. i'd like to know how to put the permission path back.
execute xp_logininfo 'ad\account','all'
¤ §unshine ¤
May 12, 2020 at 7:39 pm
It's not really something you manually populate. The permission path displays the group that allows access based on the AD group or groups added as logins. If you have a windows account with nothing in the permissions path, that typically means they access SQL Server through their individual account rather than an AD group. If it used to be populated with a group, the user is likely no longer a member of that AD group.
Sue
May 12, 2020 at 7:54 pm
ok. Thank you!
¤ §unshine ¤
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply