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
|
EXEC sp_configure
'contained database authentication', 1;
RECONFIGURE;
DROP LOGIN :NAME;
DROP DATABASE :NAME;
CREATE DATABASE :NAME
CONTAINMENT=PARTIAL;
\set QNAME "''":NAME"''"
\set SQL 'CREATE LOGIN ':NAME' WITH PASSWORD=':QNAME', CHECK_POLICY=OFF, DEFAULT_DATABASE=':NAME';'
EXEC [:NAME].[dbo].[sp_executesql] N:'SQL'
\set SQL 'CREATE USER ':NAME' FOR LOGIN ':NAME' WITH DEFAULT_SCHEMA=':NAME';'
EXEC [:NAME].[dbo].[sp_executesql] N:'SQL';
\set SQL 'CREATE SCHEMA ':NAME' AUTHORIZATION ':NAME';'
EXEC [:NAME].[dbo].[sp_executesql] N:'SQL';
\set SQL 'EXEC sp_addrolemember db_owner, ':QNAME';'
EXEC [:NAME].[dbo].[sp_executesql] N:'SQL';
-- original reconnect version:
--
--\connect 'sqlserver://localhost/':NAME
--
--CREATE LOGIN :NAME
-- WITH
-- PASSWORD=:'PASS',
-- CHECK_POLICY=OFF,
-- DEFAULT_DATABASE=:NAME;
--
--CREATE USER :NAME
-- FOR LOGIN :NAME
-- WITH DEFAULT_SCHEMA=:NAME;
--
--CREATE SCHEMA :NAME AUTHORIZATION :NAME;
--
--EXEC sp_addrolemember 'db_owner', :'NAME';
|
