Creating a Windows Login : LOGIN « User Role « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. User Role
  3. LOGIN
CREATE LOGIN [YourID\Danny]
FROM WINDOWS
WITH DEFAULT_DATABASE = YourDatabaseName,
DEFAULT_LANGUAGE = English
GO

CREATE LOGIN [YourID\DBAs]
FROM WINDOWS
WITH DEFAULT_DATABASE= YourDatabaseName
GO








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