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, 4671🔥, 0💬
Popular Posts:
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...