General MySQL Oracle SQL Server

Verifying a User Name with SQLCMD Tool in SQL Server

Q

How To Verify a User name with SQLCMD Tool in SQL Server?

✍: FYIcenter.com

A

The quickest way to verify a user name in a database is probably to use the SQLCMD tool. You can connect to the server, select the database, and check which user name is linked the current login name as shown below.

Start a command window and enter the following command: 

C:\>SQLCMD -S LOCALHOST\SQLEXPRESS -U Fyi_Login -P IYF
1> USE FyiCenterData;
2> GO
Changed database context to 'FyiCenterData'.

1> PRINT User_Name();
2> GO
Fyi_User

This shows user "Fyi_User" in database "FyiCenterData" is linked to login name "Fyi_Login".

 

⇒ "ALTER USER" - Changing the Name of a Database User in SQL Server

⇐ Finding the Login Name Linked to a Given User Name in SQL Server

⇑ Managing Security, Login and User in SQL Server

⇑⇑ SQL Server Database Tutorials

2017-08-25, 4877🔥, 0💬

General MySQL Oracle SQL Server