Viewing SQL Server Logins : LOGIN « User Role « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. User Role
  3. LOGIN
SELECT name, sid
FROM sys.server_principals
WHERE type_desc IN ('SQL_LOGIN')
ORDER BY name








28.7.LOGIN
28.7.1.Creating a SQL Server Login
28.7.2.Viewing SQL Server Logins
28.7.3.Creating a Windows Login
28.7.4.Viewing Windows Logins
28.7.5.Altering a Windows Login
28.7.6.Dropping a Windows Login
28.7.7.Denying SQL Server Access to a Windows User or Group
28.7.8.Creates a new Windows login and then maps that login to a new database user
28.7.9.Create a proxy login from the certificate
28.7.10.Create a proxy user and grant access to the schema
28.7.11.DROP LOGIN
28.7.12.Altering a SQL Server Login
28.7.13.Dropping a SQL Login