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, 1504👍, 0💬
Popular Posts:
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...