PROMPT Creating Nitil Roles...
CREATE ROLE NITIL_USER;
CREATE ROLE NITIL_POW_USER;
CREATE ROLE NITIL_MODELLER;
CREATE ROLE NITIL_ADMIN;

REVOKE ALL PRIVILEGES ON NITIL.CG_CODE_CONTROLS FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.CG_REF_CODES FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CIT_RELATION_TYPES FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_ATTRIBUTES FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTIES FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_TYPES FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_VALUES FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_RELATIONS FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPES FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPE_RELATIONS FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CONFIG_ITEMS FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_EXCEPTIONS FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_LOCATIONS FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_MESSAGES FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_OPERATIONS FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_PARAMETERS FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_POSITIONS FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_ADD_REMOVE_PROGRAMS FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_CDROM FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_COMPUTER_SYSTEM FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_DESKTOP_MONITOR FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_DISK FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_IDE_CONTROLLER FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_MODEM_DEVICE FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_MOTHERBOARD_DEVICE FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_NETWORK_ADAPTER FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_NETWORK_ADAPTER_CONFIG FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_OPERATING_SYSTEM FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_PARALLEL_PORT FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_PC_BIOS FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_PROCESSOR FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_SCSI_CONTROLLER FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_SERVICE FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_SOUND_DEVICE FROM PUBLIC;

REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_SYSTEM_ENCLOSURE FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_TAPE_DRIVE FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_USB_CONTROLLER FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_X86_PC_MEMORY FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_USERS FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.CG_CODE_CONTROLS_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CIT_RELATION_TYPES_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTIES_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_TYPES_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_VALUES_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPES_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPE_RELATIONS_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIA_MAIN_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIPT_MAIN_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIPV_AFF_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIP_AFF_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIR_MAIN_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CITRT_AFF_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CITRT_MAIN_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIPT_MAIN_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIPV_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIP_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CITR_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_MAIN_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_TREE_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_ARCHIVE_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_BROWSE_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_DETAILS_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CIA_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CIR_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CI_BROWSE_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CI_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_MAIN_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_LCN_MAIN_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_LCN_TREE_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_MSG_MAIN_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_PSN_MAIN_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_USR_MAIN_V FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CIT_RELATION_TYPES FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_ATTRIBUTES FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_PROPERTIES FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_PROPERTY_TYPES FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_PROPERTY_VALUES FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_RELATIONS FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_TYPES FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_TYPE_RELATIONS FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CONFIG_ITEMS FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_LOCATIONS FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_MESSAGES FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_OPERATIONS FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_POSITIONS FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_USERS FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CARD_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CIT_RELATION_TYPES_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_ATTRIBUTES_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTIES_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_TYPES_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_VALUES_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_RELATIONS_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPES_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPE_RELATIONS_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CONFIG_ITEMS_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CORE_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_ERROR_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIA_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIPT_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIR_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CITRT_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIPV_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIP_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CITR_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_LCN_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_MSG_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_OPN_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_USR_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_IMPORTER_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_LOCATIONS_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_OPERATIONS_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_POSITIONS_P FROM PUBLIC;
REVOKE ALL PRIVILEGES ON NITIL.NIT_USERS_P FROM PUBLIC;

REVOKE ALL PRIVILEGES ON NITIL.NIT_SEQ FROM PUBLIC;

-- Creating Privileges for role NITIL_USER (for Finance, ISO audit and other non-IT people)

-- Tables
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CIT_RELATION_TYPES FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_ATTRIBUTES FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_PROPERTIES FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_PROPERTY_TYPES FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_PROPERTY_VALUES FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_RELATIONS FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_TYPES FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_TYPE_RELATIONS FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CONFIG_ITEMS FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_LOCATIONS FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_MESSAGES FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_OPERATIONS FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_POSITIONS FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_USERS FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG_CODE_CONTROLS FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG_CODE_CONTROLS_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG_REF_CODES FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CARD_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CIT_RELATION_TYPES FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CIT_RELATION_TYPES_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CIT_RELATION_TYPES_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_ATTRIBUTES FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_ATTRIBUTES_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTIES FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTIES_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTIES_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_TYPES FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_TYPES_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_TYPES_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_VALUES FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_VALUES_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_VALUES_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_RELATIONS FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_RELATIONS_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPES FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPES_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPES_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPE_RELATIONS FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPE_RELATIONS_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPE_RELATIONS_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CONFIG_ITEMS FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CONFIG_ITEMS_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CORE_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_ERROR_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_EXCEPTIONS FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIA_MAIN_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIA_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIPT_MAIN_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIPT_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIPV_AFF_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIP_AFF_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIR_MAIN_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIR_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CITRT_AFF_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CITRT_MAIN_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CITRT_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIPT_MAIN_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIPV_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIPV_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIP_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIP_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CITR_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CITR_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_MAIN_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_TREE_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_ARCHIVE_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_BROWSE_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_DETAILS_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CIA_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CIR_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CI_BROWSE_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CI_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_MAIN_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_LCN_MAIN_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_LCN_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_LCN_TREE_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_MSG_MAIN_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_MSG_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_OPN_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_PSN_MAIN_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_USR_MAIN_V FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_USR_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_IMPORTER_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_LOCATIONS FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_LOCATIONS_P FROM NITIL_USER;

REVOKE ALL PRIVILEGES ON NITIL.NIT_MESSAGES FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_OPERATIONS FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_OPERATIONS_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_PARAMETERS FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_POSITIONS FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_POSITIONS_P FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_ADD_REMOVE_PROGRAMS FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_CDROM FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_COMPUTER_SYSTEM FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_DESKTOP_MONITOR FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_DISK FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_IDE_CONTROLLER FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_MODEM_DEVICE FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_MOTHERBOARD_DEVICE FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_NETWORK_ADAPTER FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_NETWORK_ADAPTER_CONFIG FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_OPERATING_SYSTEM FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_PARALLEL_PORT FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_PC_BIOS FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_PROCESSOR FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_SCSI_CONTROLLER FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_SERVICE FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_SOUND_DEVICE FROM NITIL_USER;

REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_SYSTEM_ENCLOSURE FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_TAPE_DRIVE FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_USB_CONTROLLER FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_X86_PC_MEMORY FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_USERS FROM NITIL_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_USERS_P FROM NITIL_USER;

GRANT CREATE SESSION TO NITIL_USER;

GRANT SELECT ON NITIL.CG_CODE_CONTROLS TO NITIL_USER;
GRANT SELECT ON NITIL.CG_REF_CODES TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_CIT_RELATION_TYPES TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_CI_ATTRIBUTES TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_CI_PROPERTIES TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_CI_PROPERTY_TYPES TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_CI_PROPERTY_VALUES TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_CI_RELATIONS TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_CI_TYPES TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_CI_TYPE_RELATIONS TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_CONFIG_ITEMS TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_EXCEPTIONS TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_LOCATIONS TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_MESSAGES TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_OPERATIONS TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_PARAMETERS TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_POSITIONS TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_USERS TO NITIL_USER;
-- Views
GRANT SELECT ON NITIL.CG_CODE_CONTROLS_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_CIT_RELATION_TYPES_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_CI_PROPERTIES_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_CI_PROPERTY_TYPES_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_CI_PROPERTY_VALUES_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_CI_TYPES_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_CI_TYPE_RELATIONS_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CIA_MAIN_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CIPT_MAIN_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CIPV_AFF_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CIP_AFF_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CIR_MAIN_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CITRT_AFF_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CITRT_MAIN_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CIT_CIPT_MAIN_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CIT_CIPV_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CIT_CIP_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CIT_CITR_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CIT_MAIN_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CIT_TREE_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CI_ARCHIVE_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CI_BROWSE_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CI_DETAILS_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CI_LIFE_CIA_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CI_LIFE_CIR_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CI_LIFE_CI_BROWSE_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CI_LIFE_CI_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_CI_MAIN_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_LCN_MAIN_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_LCN_TREE_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_MSG_MAIN_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_PSN_MAIN_V TO NITIL_USER;
GRANT SELECT ON NITIL.NIT_F_USR_MAIN_V TO NITIL_USER;


GRANT EXECUTE ON NITIL.CG$NIT_CIT_RELATION_TYPES TO NITIL_USER;
GRANT EXECUTE ON NITIL.CG$NIT_CI_ATTRIBUTES TO NITIL_USER;
GRANT EXECUTE ON NITIL.CG$NIT_CI_PROPERTIES TO NITIL_USER;
GRANT EXECUTE ON NITIL.CG$NIT_CI_PROPERTY_TYPES TO NITIL_USER;
GRANT EXECUTE ON NITIL.CG$NIT_CI_PROPERTY_VALUES TO NITIL_USER;
GRANT EXECUTE ON NITIL.CG$NIT_CI_RELATIONS TO NITIL_USER;
GRANT EXECUTE ON NITIL.CG$NIT_CI_TYPES TO NITIL_USER;
GRANT EXECUTE ON NITIL.CG$NIT_CI_TYPE_RELATIONS TO NITIL_USER;
GRANT EXECUTE ON NITIL.CG$NIT_CONFIG_ITEMS TO NITIL_USER;
GRANT EXECUTE ON NITIL.CG$NIT_LOCATIONS TO NITIL_USER;
GRANT EXECUTE ON NITIL.CG$NIT_MESSAGES TO NITIL_USER;
GRANT EXECUTE ON NITIL.CG$NIT_OPERATIONS TO NITIL_USER;
GRANT EXECUTE ON NITIL.CG$NIT_POSITIONS TO NITIL_USER;
GRANT EXECUTE ON NITIL.CG$NIT_USERS TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_CARD_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_CIT_RELATION_TYPES_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_CI_ATTRIBUTES_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_CI_PROPERTIES_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_CI_PROPERTY_TYPES_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_CI_PROPERTY_VALUES_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_CI_RELATIONS_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_CI_TYPES_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_CI_TYPE_RELATIONS_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_CONFIG_ITEMS_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_CORE_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_ERROR_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_F_CIA_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_F_CIPT_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_F_CIR_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_F_CITRT_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_F_CIT_CIPV_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_F_CIT_CIP_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_F_CIT_CITR_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_F_CIT_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_F_CI_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_F_LCN_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_F_MSG_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_F_OPN_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_F_USR_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_LOCATIONS_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_OPERATIONS_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_POSITIONS_P TO NITIL_USER;
GRANT EXECUTE ON NITIL.NIT_USERS_P TO NITIL_USER;


-- Creating Privileges for role NITIL_POW_USER (for IT IS and PA-s)

REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CIT_RELATION_TYPES FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_ATTRIBUTES FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_PROPERTIES FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_PROPERTY_TYPES FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_PROPERTY_VALUES FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_RELATIONS FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_TYPES FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_TYPE_RELATIONS FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CONFIG_ITEMS FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_LOCATIONS FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_MESSAGES FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_OPERATIONS FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_POSITIONS FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_USERS FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG_CODE_CONTROLS FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG_CODE_CONTROLS_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.CG_REF_CODES FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CARD_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CIT_RELATION_TYPES FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CIT_RELATION_TYPES_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CIT_RELATION_TYPES_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_ATTRIBUTES FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_ATTRIBUTES_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTIES FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTIES_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTIES_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_TYPES FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_TYPES_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_TYPES_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_VALUES FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_VALUES_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_VALUES_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_RELATIONS FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_RELATIONS_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPES FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPES_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPES_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPE_RELATIONS FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPE_RELATIONS_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPE_RELATIONS_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CONFIG_ITEMS FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CONFIG_ITEMS_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CORE_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_ERROR_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_EXCEPTIONS FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIA_MAIN_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIA_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIPT_MAIN_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIPT_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIPV_AFF_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIP_AFF_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIR_MAIN_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIR_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CITRT_AFF_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CITRT_MAIN_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CITRT_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIPT_MAIN_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIPV_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIPV_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIP_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIP_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CITR_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CITR_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_MAIN_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_TREE_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_ARCHIVE_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_BROWSE_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_DETAILS_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CIA_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CIR_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CI_BROWSE_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CI_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_MAIN_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_LCN_MAIN_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_LCN_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_LCN_TREE_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_MSG_MAIN_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_MSG_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_OPN_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_PSN_MAIN_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_USR_MAIN_V FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_USR_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_IMPORTER_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_LOCATIONS FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_LOCATIONS_P FROM NITIL_POW_USER;

REVOKE ALL PRIVILEGES ON NITIL.NIT_MESSAGES FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_OPERATIONS FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_OPERATIONS_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_PARAMETERS FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_POSITIONS FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_POSITIONS_P FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_ADD_REMOVE_PROGRAMS FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_CDROM FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_COMPUTER_SYSTEM FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_DESKTOP_MONITOR FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_DISK FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_IDE_CONTROLLER FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_MODEM_DEVICE FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_MOTHERBOARD_DEVICE FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_NETWORK_ADAPTER FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_NETWORK_ADAPTER_CONFIG FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_OPERATING_SYSTEM FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_PARALLEL_PORT FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_PC_BIOS FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_PROCESSOR FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_SCSI_CONTROLLER FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_SERVICE FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_SOUND_DEVICE FROM NITIL_POW_USER;

REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_SYSTEM_ENCLOSURE FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_TAPE_DRIVE FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_USB_CONTROLLER FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_X86_PC_MEMORY FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_USERS FROM NITIL_POW_USER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_USERS_P FROM NITIL_POW_USER;

GRANT NITIL_USER TO NITIL_POW_USER;

GRANT SELECT ON NITIL.NIT_SEQ TO NITIL_POW_USER;

GRANT INSERT, UPDATE ON NITIL.NIT_CI_ATTRIBUTES TO NITIL_POW_USER;
GRANT INSERT, UPDATE ON NITIL.NIT_CI_RELATIONS TO NITIL_POW_USER;
GRANT INSERT, UPDATE ON NITIL.NIT_CONFIG_ITEMS TO NITIL_POW_USER;
GRANT INSERT, UPDATE ON NITIL.NIT_POSITIONS TO NITIL_POW_USER;
GRANT INSERT, UPDATE ON NITIL.NIT_OPERATIONS TO NITIL_POW_USER;

GRANT INSERT ON NITIL.NIT_EXCEPTIONS TO NITIL_POW_USER;

GRANT SELECT ON NITIL.NIT_SMS_ADD_REMOVE_PROGRAMS TO NITIL_POW_USER;
GRANT SELECT ON NITIL.NIT_SMS_CDROM TO NITIL_POW_USER;
GRANT SELECT ON NITIL.NIT_SMS_COMPUTER_SYSTEM TO NITIL_POW_USER;
GRANT SELECT ON NITIL.NIT_SMS_DESKTOP_MONITOR TO NITIL_POW_USER;
GRANT SELECT ON NITIL.NIT_SMS_DISK TO NITIL_POW_USER;
GRANT SELECT ON NITIL.NIT_SMS_IDE_CONTROLLER TO NITIL_POW_USER;
GRANT SELECT ON NITIL.NIT_SMS_MODEM_DEVICE TO NITIL_POW_USER;
GRANT SELECT ON NITIL.NIT_SMS_MOTHERBOARD_DEVICE TO NITIL_POW_USER;
GRANT SELECT ON NITIL.NIT_SMS_NETWORK_ADAPTER TO NITIL_POW_USER;
GRANT SELECT ON NITIL.NIT_SMS_NETWORK_ADAPTER_CONFIG TO NITIL_POW_USER;
GRANT SELECT ON NITIL.NIT_SMS_OPERATING_SYSTEM TO NITIL_POW_USER;
GRANT SELECT ON NITIL.NIT_SMS_PARALLEL_PORT TO NITIL_POW_USER;
GRANT SELECT ON NITIL.NIT_SMS_PC_BIOS TO NITIL_POW_USER;
GRANT SELECT ON NITIL.NIT_SMS_PROCESSOR TO NITIL_POW_USER;
GRANT SELECT ON NITIL.NIT_SMS_SCSI_CONTROLLER TO NITIL_POW_USER;
GRANT SELECT ON NITIL.NIT_SMS_SERVICE TO NITIL_POW_USER;
GRANT SELECT ON NITIL.NIT_SMS_SOUND_DEVICE TO NITIL_POW_USER;
GRANT SELECT ON NITIL.NIT_SMS_TAPE_DRIVE TO NITIL_POW_USER;
GRANT SELECT ON NITIL.NIT_SMS_USB_CONTROLLER TO NITIL_POW_USER;
GRANT SELECT ON NITIL.NIT_SMS_X86_PC_MEMORY TO NITIL_POW_USER;

GRANT SELECT ON NITIL.NIT_SMS_SYSTEM_ENCLOSURE TO NITIL_POW_USER;

GRANT EXECUTE ON NITIL.NIT_IMPORTER_P TO NITIL_POW_USER;

-- Creating Privileges for role NITIL_MODELLER

-- Tables
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CIT_RELATION_TYPES FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_ATTRIBUTES FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_PROPERTIES FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_PROPERTY_TYPES FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_PROPERTY_VALUES FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_RELATIONS FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_TYPES FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CI_TYPE_RELATIONS FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_CONFIG_ITEMS FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_LOCATIONS FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_MESSAGES FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_OPERATIONS FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_POSITIONS FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.CG$NIT_USERS FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.CG_CODE_CONTROLS FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.CG_CODE_CONTROLS_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.CG_REF_CODES FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CARD_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CIT_RELATION_TYPES FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CIT_RELATION_TYPES_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CIT_RELATION_TYPES_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_ATTRIBUTES FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_ATTRIBUTES_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTIES FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTIES_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTIES_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_TYPES FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_TYPES_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_TYPES_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_VALUES FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_VALUES_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_VALUES_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_RELATIONS FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_RELATIONS_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPES FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPES_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPES_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPE_RELATIONS FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPE_RELATIONS_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CI_TYPE_RELATIONS_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CONFIG_ITEMS FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CONFIG_ITEMS_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_CORE_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_ERROR_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_EXCEPTIONS FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIA_MAIN_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIA_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIPT_MAIN_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIPT_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIPV_AFF_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIP_AFF_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIR_MAIN_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIR_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CITRT_AFF_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CITRT_MAIN_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CITRT_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIPT_MAIN_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIPV_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIPV_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIP_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIP_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CITR_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_CITR_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_MAIN_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CIT_TREE_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_ARCHIVE_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_BROWSE_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_DETAILS_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CIA_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CIR_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CI_BROWSE_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CI_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_MAIN_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_CI_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_LCN_MAIN_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_LCN_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_LCN_TREE_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_MSG_MAIN_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_MSG_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_OPN_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_PSN_MAIN_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_USR_MAIN_V FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_F_USR_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_IMPORTER_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_LOCATIONS FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_LOCATIONS_P FROM NITIL_MODELLER;

REVOKE ALL PRIVILEGES ON NITIL.NIT_MESSAGES FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_OPERATIONS FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_OPERATIONS_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_PARAMETERS FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_POSITIONS FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_POSITIONS_P FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_ADD_REMOVE_PROGRAMS FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_CDROM FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_COMPUTER_SYSTEM FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_DESKTOP_MONITOR FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_DISK FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_IDE_CONTROLLER FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_MODEM_DEVICE FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_MOTHERBOARD_DEVICE FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_NETWORK_ADAPTER FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_NETWORK_ADAPTER_CONFIG FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_OPERATING_SYSTEM FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_PARALLEL_PORT FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_PC_BIOS FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_PROCESSOR FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_SCSI_CONTROLLER FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_SERVICE FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_SOUND_DEVICE FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_SYSTEM_ENCLOSURE FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_TAPE_DRIVE FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_USB_CONTROLLER FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_SMS_X86_PC_MEMORY FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_USERS FROM NITIL_MODELLER;
REVOKE ALL PRIVILEGES ON NITIL.NIT_USERS_P FROM NITIL_MODELLER;

GRANT NITIL_POW_USER TO NITIL_MODELLER;

GRANT INSERT, UPDATE, DELETE ON NITIL.CG_CODE_CONTROLS TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.CG_REF_CODES TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_CIT_RELATION_TYPES TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_CI_ATTRIBUTES TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_CI_PROPERTIES TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_CI_PROPERTY_TYPES TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_CI_PROPERTY_VALUES TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_CI_RELATIONS TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_CI_TYPES TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_CI_TYPE_RELATIONS TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_CONFIG_ITEMS TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_EXCEPTIONS TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_LOCATIONS TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_MESSAGES TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_OPERATIONS TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_PARAMETERS TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_POSITIONS TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_ADD_REMOVE_PROGRAMS TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_CDROM TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_COMPUTER_SYSTEM TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_DESKTOP_MONITOR TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_DISK TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_IDE_CONTROLLER TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_MODEM_DEVICE TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_MOTHERBOARD_DEVICE TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_NETWORK_ADAPTER TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_NETWORK_ADAPTER_CONFIG TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_OPERATING_SYSTEM TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_PARALLEL_PORT TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_PC_BIOS TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_PROCESSOR TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_SCSI_CONTROLLER TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_SERVICE TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_SOUND_DEVICE TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_TAPE_DRIVE TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_USB_CONTROLLER TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_X86_PC_MEMORY TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_SMS_SYSTEM_ENCLOSURE TO NITIL_MODELLER;
GRANT INSERT, UPDATE, DELETE ON NITIL.NIT_USERS TO NITIL_MODELLER;

-- Creating Privileges for role NITIL_ADMIN (De facto Administrator, but not DBA, for example: Szabi or Tamas)

GRANT RESOURCE TO NITIL_ADMIN;

GRANT ALL PRIVILEGES ON NITIL.CG$NIT_CIT_RELATION_TYPES TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.CG$NIT_CI_ATTRIBUTES TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.CG$NIT_CI_PROPERTIES TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.CG$NIT_CI_PROPERTY_TYPES TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.CG$NIT_CI_PROPERTY_VALUES TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.CG$NIT_CI_RELATIONS TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.CG$NIT_CI_TYPES TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.CG$NIT_CI_TYPE_RELATIONS TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.CG$NIT_CONFIG_ITEMS TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.CG$NIT_LOCATIONS TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.CG$NIT_MESSAGES TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.CG$NIT_OPERATIONS TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.CG$NIT_POSITIONS TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.CG$NIT_USERS TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.CG_CODE_CONTROLS TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.CG_CODE_CONTROLS_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.CG_REF_CODES TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CARD_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CIT_RELATION_TYPES TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CIT_RELATION_TYPES_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CIT_RELATION_TYPES_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CI_ATTRIBUTES TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CI_ATTRIBUTES_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTIES TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTIES_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTIES_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_TYPES TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_TYPES_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_TYPES_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_VALUES TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_VALUES_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CI_PROPERTY_VALUES_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CI_RELATIONS TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CI_RELATIONS_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CI_TYPES TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CI_TYPES_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CI_TYPES_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CI_TYPE_RELATIONS TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CI_TYPE_RELATIONS_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CI_TYPE_RELATIONS_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CONFIG_ITEMS TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CONFIG_ITEMS_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_CORE_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_ERROR_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_EXCEPTIONS TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CIA_MAIN_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CIA_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CIPT_MAIN_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CIPT_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CIPV_AFF_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CIP_AFF_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CIR_MAIN_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CIR_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CITRT_AFF_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CITRT_MAIN_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CITRT_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIPT_MAIN_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIPV_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIPV_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIP_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CIT_CIP_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CIT_CITR_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CIT_CITR_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CIT_MAIN_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CIT_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CIT_TREE_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CI_ARCHIVE_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CI_BROWSE_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CI_DETAILS_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CIA_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CIR_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CI_BROWSE_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CI_LIFE_CI_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CI_MAIN_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_CI_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_LCN_MAIN_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_LCN_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_LCN_TREE_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_MSG_MAIN_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_MSG_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_OPN_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_PSN_MAIN_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_USR_MAIN_V TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_F_USR_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_IMPORTER_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_LOCATIONS TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_LOCATIONS_P TO NITIL_ADMIN;

GRANT ALL PRIVILEGES ON NITIL.NIT_MESSAGES TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_OPERATIONS TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_OPERATIONS_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_PARAMETERS TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_POSITIONS TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_POSITIONS_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_ADD_REMOVE_PROGRAMS TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_CDROM TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_COMPUTER_SYSTEM TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_DESKTOP_MONITOR TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_DISK TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_IDE_CONTROLLER TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_MODEM_DEVICE TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_MOTHERBOARD_DEVICE TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_NETWORK_ADAPTER TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_NETWORK_ADAPTER_CONFIG TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_OPERATING_SYSTEM TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_PARALLEL_PORT TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_PC_BIOS TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_PROCESSOR TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_SCSI_CONTROLLER TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_SERVICE TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_SOUND_DEVICE TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_TAPE_DRIVE TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_USB_CONTROLLER TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_X86_PC_MEMORY TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_SMS_SYSTEM_ENCLOSURE TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_USERS TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_USERS_P TO NITIL_ADMIN;
GRANT ALL PRIVILEGES ON NITIL.NIT_IMPORTER_P TO NITIL_ADMIN;


GRANT CREATE SYNONYM TO NITIL_ADMIN;
GRANT CREATE PUBLIC SYNONYM TO NITIL_ADMIN;
GRANT DROP PUBLIC SYNONYM TO NITIL_ADMIN;
GRANT CREATE VIEW TO NITIL_ADMIN;
GRANT CREATE MATERIALIZED VIEW TO NITIL_ADMIN;
GRANT CREATE TABLE TO NITIL_ADMIN;
GRANT CREATE PROCEDURE TO NITIL_ADMIN;
GRANT CREATE TYPE TO NITIL_ADMIN;
GRANT CREATE OPERATOR TO NITIL_ADMIN;
GRANT CREATE SEQUENCE TO NITIL_ADMIN;
GRANT ANALYZE ANY TO NITIL_ADMIN;

PROMPT Done.

