-
Notifications
You must be signed in to change notification settings - Fork 0
/
25 - Ajustar permissões e usuarios.sql
92 lines (74 loc) · 2.62 KB
/
25 - Ajustar permissões e usuarios.sql
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
use Wms_MTZ
select * from Formulario where NomFormulario like '%arma%'
select t4.CodUsuario, LoginUsuario,t4.Ativo,UsaColetor,Admin,t4.CodOperacao,t4.CodFormulario,t4.NomOperacao from Usuario t3 join (
select t1.CodOperacao,CodFormulario,NomOperacao,CodUsuario, Ativo from Operacao t1 join PermOper t2 on t1.CodOperacao=t2.CodOperacao) as t4 on t3.CodUsuario=t4.CodUsuario
where t4.CodFormulario=151
select t4.CodUsuario, LoginUsuario,t4.NomOperacao from Usuario t3 join (
select t1.CodOperacao,CodFormulario,NomOperacao,CodUsuario, Ativo from Operacao t1 join PermOper t2 on t1.CodOperacao=t2.CodOperacao) as t4 on t3.CodUsuario=t4.CodUsuario
where t3.NomeUsuario like '%erisom%' order by LoginUsuario
select distinct t4.CodUsuario, LoginUsuario from Usuario t3 join (
select t1.CodOperacao,CodFormulario,NomOperacao,CodUsuario, Ativo from Operacao t1 join PermOper t2 on t1.CodOperacao=t2.CodOperacao) as t4 on t3.CodUsuario=t4.CodUsuario
where t4.CodFormulario=151 order by CodUsuario
delete from PermOper where CodOperacao in ('62','63','104','105','61') and CodUsuario in (
'208',
'267',
'268',
'277',
'294',
'304',
'312',
'313',
'314',
'338',
'391',
'392',
'393',
'394',
'395',
'396',
'397',
'398',
'404',
'448',
'450',
'463',
'473',
'1000')
delete from PermForm where CodFormulario=21 and CodUsuario in (
'208',
'267',
'268',
'277',
'294',
'304',
'312',
'313',
'314',
'338',
'391',
'392',
'393',
'394',
'395',
'396',
'397',
'398',
'404',
'448',
'450',
'463',
'473',
'1000')
delete from PermOper where CodOperacao in ('58') and CodUsuario in ('140')
insert into PermOper (CodOperacao,CodUsuario,DatCadastro) values (118,117,GETDATE())
insert into PermOper (CodOperacao,CodUsuario,DatCadastro) values (118,210,GETDATE())
insert into PermOper (CodOperacao,CodUsuario,DatCadastro) values (118,215,GETDATE())
insert into PermOper (CodOperacao,CodUsuario,DatCadastro) values (118,148,GETDATE())
insert into PermOper (CodOperacao,CodUsuario,DatCadastro) values (118,128,GETDATE())
insert into PermOper (CodOperacao,CodUsuario,DatCadastro) values (118,102,GETDATE())
insert into PermForm (CodFormulario,CodUsuario,DatCadastro) values (2,117,GETDATE())
insert into PermForm (CodFormulario,CodUsuario,DatCadastro) values (2,210,GETDATE())
insert into PermForm (CodFormulario,CodUsuario,DatCadastro) values (2,215,GETDATE())
insert into PermForm (CodFormulario,CodUsuario,DatCadastro) values (2,148,GETDATE())
insert into PermForm (CodFormulario,CodUsuario,DatCadastro) values (2,128,GETDATE())
insert into PermForm (CodFormulario,CodUsuario,DatCadastro) values (2,102,GETDATE())