CREATE ROLE "TBI_USER"; CREATE ROLE "TBI_WORKBENCH"; CREATE ROLE "TBI_SERVICE"; GRANT SELECT ON BIM_REPOSITORY.BIM_ServiceAccount TO TBI_USER; GRANT SELECT, INSERT, UPDATE, DELETE ON BIM_REPOSITORY.BIW_Schema TO TBI_WORKBENCH; GRANT SELECT, INSERT, UPDATE, DELETE ON BIM_REPOSITORY.BIW_SchemaXML TO TBI_WORKBENCH; GRANT SELECT, INSERT, UPDATE, DELETE ON BIM_REPOSITORY.BIW_SchemaGrants TO TBI_WORKBENCH; GRANT SELECT, INSERT, UPDATE, DELETE ON BIM_REPOSITORY.BIM_InstanceSettings TO TBI_WORKBENCH; GRANT SELECT, INSERT, UPDATE, DELETE ON BIM_REPOSITORY.BIM_ServiceAccount TO TBI_WORKBENCH; GRANT SELECT ON BIM_REPOSITORY.BIM_Schema_VW TO TBI_SERVICE; GRANT SELECT ON BIM_REPOSITORY.BIM_SchemaXML_VW TO TBI_SERVICE; GRANT SELECT ON BIM_REPOSITORY.BIM_SchemaGrants_VW TO TBI_SERVICE; GRANT SELECT ON BIM_REPOSITORY.BIM_InstanceSettings TO TBI_SERVICE;