Collections:
sys.database_principals - Listing All User Names in SQL Server
How To List All User Names in a Database in SQL Server?
✍: FYIcenter.com
If you want to see a list of all user names defined in a database, you can use the system view, sys.database_principals as shown in this tutorial exercise:
-- Login with sa -- Select a database USE FyiCenterData; GO -- List all user names SELECT name, sid, type, type_desc FROM sys.database_principals WHERE type = 'S'; GO name sid type type_desc -------------------- ------------------------ ---- --------- dbo 0x01 S SQL_USER guest 0x00 S SQL_USER INFORMATION_SCHEMA NULL S SQL_USER sys NULL S SQL_USER Fyi_User 0x5EB8701EAEBAA74F86F... S SQL_USER (5 row(s) affected)
As you can see, there are 5 user names defined in "FyiCenterData". 4 are defined by SQL Server during the database creation process. Only the last one "Fyi_User" was defined by you in the previous tutorial.
⇒ Finding the Login Name Linked to a Given User Name in SQL Server
⇐ "CREATE USER" - Creating a User Name in a Database in SQL Server
2017-08-25, 5097🔥, 0💬
Popular Posts:
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...