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, 5212🔥, 0💬
Popular Posts:
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...