-
Notifications
You must be signed in to change notification settings - Fork 4
Expand file tree
/
Copy pathexternal-database-example.yaml
More file actions
179 lines (177 loc) · 3.85 KB
/
external-database-example.yaml
File metadata and controls
179 lines (177 loc) · 3.85 KB
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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
---
apiVersion: v1
kind: Namespace
metadata:
name: external-db-example
---
# Secret containing credentials for the external SQL Server
apiVersion: v1
kind: Secret
metadata:
name: external-sql-secret
namespace: external-db-example
type: Opaque
stringData:
username: sa
password: SuperSecretPassword123!
---
apiVersion: sql-server.dotkube.io/v1alpha1
kind: ExternalDatabase
metadata:
name: external-db-sample
namespace: external-db-example
spec:
serverUrl: localhost,1435
databaseName: AlreadyExistingDB
secretName: external-sql-secret
---
apiVersion: sql-server.dotkube.io/v1alpha1
kind: SQLServerLogin
metadata:
name: app-login
namespace: external-db-example
spec:
databaseRef: external-db-sample
loginName: app-user
authenticationType: SQL
secretName: app-user-secret
---
apiVersion: sql-server.dotkube.io/v1alpha1
kind: SQLServerUser
metadata:
name: app-user
namespace: external-db-example
spec:
databaseRef: external-db-sample
loginName: app-user
roles:
- db_datareader
- db_datawriter
---
apiVersion: sql-server.dotkube.io/v1alpha1
kind: SQLServerLogin
metadata:
name: reporting-login
namespace: external-db-example
spec:
databaseRef: external-db-sample
loginName: reporting-user
authenticationType: SQL
secretName: reporting-secret
---
apiVersion: sql-server.dotkube.io/v1alpha1
kind: SQLServerUser
metadata:
name: reporting-user
namespace: external-db-example
spec:
databaseRef: external-db-sample
loginName: reporting-user
roles:
- db_datareader
---
apiVersion: sql-server.dotkube.io/v1alpha1
kind: SQLServerLogin
metadata:
name: etl-login
namespace: external-db-example
spec:
databaseRef: external-db-sample
loginName: etl-service
authenticationType: SQL
secretName: etl-secret
---
apiVersion: sql-server.dotkube.io/v1alpha1
kind: SQLServerUser
metadata:
name: etl-user
namespace: external-db-example
spec:
databaseRef: external-db-sample
loginName: etl-service
roles:
- db_datareader
- db_datawriter
- db_ddladmin
---
apiVersion: sql-server.dotkube.io/v1alpha1
kind: SQLServerLogin
metadata:
name: data-scientist-login
namespace: external-db-example
spec:
databaseRef: external-db-sample
loginName: data-scientist
authenticationType: SQL
secretName: ds-secret
---
apiVersion: sql-server.dotkube.io/v1alpha1
kind: SQLServerUser
metadata:
name: data-scientist-user
namespace: external-db-example
spec:
databaseRef: external-db-sample
loginName: data-scientist
roles:
- db_datareader
---
apiVersion: sql-server.dotkube.io/v1alpha1
kind: SQLServerSchema
metadata:
name: schema-etl-staging
namespace: external-db-example
spec:
databaseRef: external-db-sample
schemaName: etl_staging
schemaOwner: etl-service
---
apiVersion: sql-server.dotkube.io/v1alpha1
kind: SQLServerSchema
metadata:
name: schema-data-science
namespace: external-db-example
spec:
databaseRef: external-db-sample
schemaName: data_science
schemaOwner: data-scientist
---
apiVersion: sql-server.dotkube.io/v1alpha1
kind: SQLServerSchema
metadata:
name: schema-audit-logs
namespace: external-db-example
spec:
databaseRef: external-db-sample
schemaName: audit_logs
schemaOwner: app-user
---
apiVersion: sql-server.dotkube.io/v1alpha1
kind: SQLServerSchema
metadata:
name: schema-legacy-archive
namespace: external-db-example
spec:
databaseRef: external-db-sample
schemaName: legacy_archive
schemaOwner: reporting-user
---
apiVersion: sql-server.dotkube.io/v1alpha1
kind: SQLServerSchema
metadata:
name: schema-geo-spatial
namespace: external-db-example
spec:
databaseRef: external-db-sample
schemaName: geo_spatial
schemaOwner: data-scientist
---
apiVersion: sql-server.dotkube.io/v1alpha1
kind: SQLServerSchema
metadata:
name: schema-hardware-telemetry
namespace: external-db-example
spec:
databaseRef: external-db-sample
schemaName: hardware_telemetry
schemaOwner: etl-service