/
Chapter4.txt
53 lines (37 loc) · 1.11 KB
/
Chapter4.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
/* Chapter 4 */
/* Try it out - Creating a Group - Step 11 */
USE [master]
GO
CREATE LOGIN [FAT-BELLY\Apress_Product_Controllers]
FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
USE [ApressFinancial]
GO
CREATE USER [FAT-BELLY\Apress_Product_Controllers]
FOR LOGIN [FAT-BELLY\Apress_Product_Controllers]
GO
/* Try it out - Programmatically Working with a Login - Step 2 */
USE [master]
GO
CREATE LOGIN [FAT-BELLY\Apress_Product_Controllers]
FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
USE [ApressFinancial]
GO
CREATE USER [FAT-BELLY\Apress_Product_Controllers]
FOR LOGIN [FAT-BELLY\Apress_Product_Controllers]
GO
/* Try it out - Programmatically Working with a Login - Step 3 */
CREATE LOGIN [FAT-BELLY\Apress_Client_Information]
FROM WINDOWS
WITH DEFAULT_DATABASE=[ApressFinancial],
DEFAULT_LANGUAGE=[us_english]
GO
/* Try it out - Creating Schemas and Adding Objects - Step 1 */
USE ApressFinancial
GO
CREATE SCHEMA TransactionDetails AUTHORIZATION dbo
/* Try it out - Creating Schemas and Adding Objects - Step 3 */
CREATE SCHEMA ShareDetails AUTHORIZATION dbo
GO
CREATE SCHEMA CustomerDetails AUTHORIZATION dbo