
-- ----------------------------------------------------------------------------
-- Generated by Role2InsertRoles.xsl
--
-- DML to merge the Chemstation related roles into Oracle DB
-- ----------------------------------------------------------------------------

DEFINE OLSCHEMANAME = &OLSCHEMANAME_FROMUSER
DEFINE ROLEINDEXOFFSET = 3000

PROMPT Add Roles Data...
    
INSERT INTO &OLSCHEMANAME..FactoryRoles
  (nSystemRoleID,RoleName,Description,bShowInLCDFContainer,bIsHiddenRole,BISINSTROLE,BISPROJROLE)
  values
  (&ROLEINDEXOFFSET+1,':CS Administrator','ChemStation Administrator role',1,0,0,0)
/
INSERT INTO &OLSCHEMANAME..FactoryRoles
  (nSystemRoleID,RoleName,Description,bShowInLCDFContainer,bIsHiddenRole,BISINSTROLE,BISPROJROLE)
  values
  (&ROLEINDEXOFFSET+2,':CS Lab Manager','ChemStation Lab Manager role',1,0,0,0)
/
INSERT INTO &OLSCHEMANAME..FactoryRoles
  (nSystemRoleID,RoleName,Description,bShowInLCDFContainer,bIsHiddenRole,BISINSTROLE,BISPROJROLE)
  values
  (&ROLEINDEXOFFSET+3,':CS Analyst','ChemStation Analyst role',1,0,0,0)
/
INSERT INTO &OLSCHEMANAME..FactoryRoles
  (nSystemRoleID,RoleName,Description,bShowInLCDFContainer,bIsHiddenRole,BISINSTROLE,BISPROJROLE)
  values
  (&ROLEINDEXOFFSET+4,':CS Operator','ChemStation Operator role',1,0,0,0)
/