update [cvt_apps].[dbo].[TIusuariosAD]
set Estado = 'Activo'
where Estado = 'Active'
update [cvt_apps].[dbo].[TIusuariosAD]
set Estado = 'Inactivo'
where Estado = 'Inactive'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Permiso (Simple)] = 'Control completo'
where [Permisos (Avanzado)] = 'Full Control, Traverse Folder / Execute File, List Folder / Read Data, Read Attributes, Read Extended Attributes, Create Files / Write Data, Create Folders / Append Data, Write Attributes, Write Extended Attributes, Delete Subfolders and Files, Delete, Read Permissions, Change Permissions, Take Ownership'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Permiso (Simple)] = 'Listado'
where [Permisos (Avanzado)] = 'Traverse Folder / Execute File, List Folder / Read Data, Read Attributes, Read Extended Attributes, Read Permissions'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Permiso (Simple)] = 'Modificar'
where [Permisos (Avanzado)] = 'Traverse Folder / Execute File, List Folder / Read Data, Read Attributes, Read Extended Attributes, Create Files / Write Data, Create Folders / Append Data, Write Attributes, Write Extended Attributes, Read Permissions'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Permiso (Simple)] = 'Modificar'
where [Permisos (Avanzado)] = 'Traverse Folder / Execute File, List Folder / Read Data, Read Attributes, Read Extended Attributes, Create Files / Write Data, Create Folders / Append Data, Write Attributes, Write Extended Attributes, Read Permissions'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Permiso (Simple)] = 'Modificar'
where [Permisos (Avanzado)] = 'Traverse Folder / Execute File, List Folder / Read Data, Read Attributes, Read Extended Attributes, Create Files / Write Data, Create Folders / Append Data, Write Attributes, Write Extended Attributes, Delete, Read Permissions'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Permiso (Simple)] = 'Modificar'
where [Permisos (Avanzado)] = 'Traverse Folder / Execute File, List Folder / Read Data, Read Attributes, Read Extended Attributes, Create Files / Write Data, Create Folders / Append Data, Write Attributes, Write Extended Attributes, Delete Subfolders and Files, Delete, Read Permissions, Change Permissions, Take Ownership'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Permiso (Simple)] = 'Modificar'
where [Permisos (Avanzado)] = 'Traverse Folder / Execute File, List Folder / Read Data, Read Attributes, Read Extended Attributes, Create Files / Write Data, Create Folders / Append Data, Write Attributes, Write Extended Attributes, Delete Subfolders and Files, Delete, Read Permissions, Change Permissions, Take Ownership'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Permiso (Simple)] = 'Modificar'
where [Permisos (Avanzado)] = 'Create Files / Write Data, Create Folders / Append Data, Write Attributes, Write Extended Attributes'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Tipo de acceso] = 'Permitir'
where [Tipo de acceso] = 'Allow'
update [cvt_apps].[dbo].[TI_permisosU]
SET [Tipo de acceso] = 'Denegar'
where [Tipo de acceso] = 'Deny'
update [cvt_apps].[dbo].[TI_permisosU]
set [Nivel 0] = case when [Nivel 0] is null then '' else [Nivel 0] end,
[Nivel 1] = case when [Nivel 1] is null then '' else [Nivel 1] end,
[Nivel 2] = case when [Nivel 2] is null then '' else [Nivel 2] end,
[Nivel 3] = case when [Nivel 3] is null then '' else [Nivel 3] end,
[Nivel 4] = case when [Nivel 4] is null then '' else [Nivel 4] end,
[Nivel 5] = case when [Nivel 5] is null then '' else [Nivel 5] end,
[Nivel 6] = case when [Nivel 6] is null then '' else [Nivel 6] end,
[Nivel 7] = case when [Nivel 7] is null then '' else [Nivel 7] end,
[Nivel 8] = case when [Nivel 8] is null then '' else [Nivel 8] end,
[Nivel 9] = case when [Nivel 9] is null then '' else [Nivel 9] end