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)
2017-08-25, 924👍, 0💬
Popular Posts:
What is Microsoft SQL Server in SQL Server? Microsoft SQL Server is a relational database management...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...