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, 3756👍, 0💬
Popular Posts:
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
Where to find answers to frequently asked questions on Introduction to Date and Time Handling in MyS...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...