PSM SSMS with Windows Auth showing PSM Shadow User Name

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

PAM Self-Hosted Articles
2 min read
L3 Networker
No ratings

Question

When logging into a MSSQL database using a Windows Domain account, SSMS shows that the user logging in is the PSM Shadow User and not the target Windows account. Why is this?

Answer

This is a known product limitation. When using MSSQL Windows authentication via PSM, the displayed username is the shadow username but the database permissions will be assigned as per the Windows AD account.

When the application is launched it is actually launched using the Windows profile of the user logged into the PSM server (the shadow user), all configuration files and settings will be saved to that shadow user's profile on the PSM server.

The target account credentials are passed to the program for authentication to resources (and also used for the applications NT/Windows SSO authentication).

This eliminates the need to have the target user's profile created on the PSM server. No permissions are needed to be given to the target user on the PSM server.

However, SSMS will only display the user name from the profile which launches it when you uses Windows Auth login.

You can see the logged on user (if they have permissions) by running the below SQL command:

***
use master; select system_user;
***
Rate this article: