Collections:
Finding the Login Name Linked to a Given User Name in SQL Server
How To Find the Login Name Linked to a Given User Name in SQL Server?
✍: FYIcenter.com
If you know a user name in a database and you want to find out which login name is linked this user name, you need to check the Security ID (SID) of the user name based on the following rules:
So the login name linked to a user name must have the SID as the user name. The tutorial exercise below shows you how to find the login name that is linked to the user name "Fyi_User":
-- Login with sa USE FyiCenterData; GO SELECT u.name AS User_Name, l.name AS Login_Name, u.sid FROM sys.server_principals l, sys.database_principals u WHERE l.sid = u.sid AND u.name = 'Fyi_User'; GO User_Name Login_Name sid ---------- ----------- ---------------------------------- Fyi_User Fyi_Login 0x5EB8701EAEBAA74F86FCF5BD8E37B8C5 (1 row(s) affected)
⇒ Verifying a User Name with SQLCMD Tool in SQL Server
⇐ sys.database_principals - Listing All User Names in SQL Server
2017-08-25, 1683🔥, 0💬
Popular Posts:
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...