1 | INSERT INTO |
---|
2 | global_sys_conf(objnam, varnam, value_, ent_id, dscrpt) |
---|
3 | SELECT |
---|
4 | 'PartialPasswordPolicy', |
---|
5 | 'minLength', |
---|
6 | '(?=\S{8,})', |
---|
7 | {ent_id}, |
---|
8 | 'Minimalna długość hasła to 8 znaków' |
---|
9 | WHERE |
---|
10 | NOT EXISTS (SELECT objnam FROM global_sys_conf WHERE objnam = 'PartialPasswordPolicy' AND varnam = 'minLength'); |
---|
11 | |
---|
12 | INSERT INTO |
---|
13 | global_sys_conf(objnam, varnam, value_, ent_id, dscrpt) |
---|
14 | SELECT |
---|
15 | 'PartialPasswordPolicy', |
---|
16 | 'maxLength', |
---|
17 | '^(\S{0,15})$', |
---|
18 | {ent_id}, |
---|
19 | 'Maksymalna długość hasła to 15 znaków' |
---|
20 | WHERE |
---|
21 | NOT EXISTS (SELECT objnam FROM global_sys_conf WHERE objnam = 'PartialPasswordPolicy' AND varnam = 'maxLength'); |
---|
22 | |
---|
23 | INSERT INTO |
---|
24 | global_sys_conf(objnam, varnam, value_, ent_id, dscrpt) |
---|
25 | SELECT |
---|
26 | 'PartialPasswordPolicy', |
---|
27 | 'minNumber', |
---|
28 | '(?=(.*\d){1})', |
---|
29 | {ent_id}, |
---|
30 | 'Hasło musi zawierać co najmniej jedną cyfrę' |
---|
31 | WHERE |
---|
32 | NOT EXISTS (SELECT objnam FROM global_sys_conf WHERE objnam = 'PartialPasswordPolicy' AND varnam = 'minNumber'); |
---|
33 | |
---|
34 | INSERT INTO |
---|
35 | global_sys_conf(objnam, varnam, value_, ent_id, dscrpt) |
---|
36 | SELECT |
---|
37 | 'PartialPasswordPolicy', |
---|
38 | 'specialCharacter', |
---|
39 | '(?=\S*[\W])', |
---|
40 | {ent_id}, |
---|
41 | 'Hasło musi zawierać co najmniej jeden znak specjalny' |
---|
42 | WHERE |
---|
43 | NOT EXISTS (SELECT objnam FROM global_sys_conf WHERE objnam = 'PartialPasswordPolicy' AND varnam = 'specialCharacter'); |
---|
44 | |
---|
45 | INSERT INTO |
---|
46 | global_sys_conf(objnam, varnam, value_, ent_id, dscrpt) |
---|
47 | SELECT |
---|
48 | 'PartialPasswordPolicy', |
---|
49 | 'uppercaseLetter', |
---|
50 | '(?=\S*[A-Z])', |
---|
51 | {ent_id}, |
---|
52 | 'Hasło musi zawierać co najmniej jedną dużą literę' |
---|
53 | WHERE |
---|
54 | NOT EXISTS (SELECT objnam FROM global_sys_conf WHERE objnam = 'PartialPasswordPolicy' AND varnam = 'uppercaseLetter'); |
---|
55 | |
---|
56 | INSERT INTO |
---|
57 | global_sys_conf(objnam, varnam, value_, ent_id, dscrpt) |
---|
58 | SELECT |
---|
59 | 'PartialPasswordPolicy', |
---|
60 | 'lowercaseLetter', |
---|
61 | '(?=\S*[a-z])', |
---|
62 | {ent_id}, |
---|
63 | 'Hasło musi zawierać co najmniej jedną małą literę' |
---|
64 | WHERE |
---|
65 | NOT EXISTS (SELECT objnam FROM global_sys_conf WHERE objnam = 'PartialPasswordPolicy' AND varnam = 'lowercaseLetter'); |
---|