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, 5039🔥, 0💬
Popular Posts:
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...