crear permiso

UPDATE dbo.REPORTS
SET REPORT_KUSAI = 5,
NAME ='EDITAR JERARQUIAS',
DESCRIPTION = 'EDITAR JERARQUIAS'
WHERE NEC_REPORT = 176


INSERT INTO dbo.CONFIG_PROFILE_REPORTS
(
    FROM_PROFILE,
    TO_PROFILE,
    NEC_REPORT
)
SELECT R.FROM_PROFILE, R.TO_PROFILE, 176 FROM dbo.CONFIG_PROFILE_REPORTS R
WHERE R.NEC_REPORT = 97


INSERT INTO dbo.REPORT_GROUPS
(
    NEC_GROUP,
    NEC_REPORT,
    POSITION
)
VALUES
(   96,      -- NEC_GROUP - int
    176,      -- NEC_REPORT - int
    1 -- POSITION - int
    )