A.4. Data Control Language (DCL)
A.4.1. Anmeldungen und Benutzer anlegen
A.4.1.1. SQL Server-Anmeldungen anlegen
Syntax:
CREATE LOGIN [Anmeldename] WITH PASSWORD = [Passwort], DEFAULT_DATABASE = [Standarddatenbank], CHECK_EXPIRATION = ON | OFF, CHECK_POLICY = ON | OFF
Beispiel:
CREATE LOGIN MediaBaseReadWrite WITH PASSWORD=N'mbrw', DEFAULT_DATABASE=master, CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
A.4.1.2. Windows-Anmeldungen anlegen
Syntax:
CREATE LOGIN [Anmeldename] FROM WINDOWS WITH DEFAULT_DATABASE = [Standarddatenbank]
Beispiel:
CREATE LOGIN VIRTUALTIGER\mmustermann FROM WINDOWS WITH DEFAULT_DATABASE=master
A.4.1.3. Datenbankbenutzer anlegen
Syntax:
CREATE USER [Benutzername] FOR LOGIN [Anmeldename]
Beispiele:
CREATE USER [MediaBaseReadOnly] ...
Get Datenbanken entwickeln mit SQL Server 2008 Express Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.