-- CMS domainId

SET @domainId = (SELECT id FROM Domain WHERE code = 'io.netfoundry.management');

-- production NetSuite API account identity

SET @netsuiteAPIIdentityId = X'3AEE3082F5D74AFEBDEAA037526D9505';

SET @netsuiteResourceTypeId = (SELECT id FROM ResourceType WHERE code = 'customer' AND domainId = @domainId);

SET @updateNetSuiteActionId = (SELECT id FROM ResourceAction WHERE code = 'read' AND resourceTypeId = @netsuiteResourceTypeId);

-- GRANT permission

INSERT INTO IdentityResourceAction (id, identityId, resourceActionId)

   (SELECT UNHEX(REPLACE(UUID(),'-','')), @netsuiteAPIIdentityId, @updateNetSuiteActionId

    WHERE NOT EXISTS(SELECT * FROM IdentityResourceAction WHERE identityId=@netsuiteAPIIdentityId AND resourceActionId=@updateNetSuiteActionId));

 

 

SET @domainId = (SELECT id FROM Domain WHERE code = 'io.netfoundry.management');

-- production NetSuite API account identity

SET @netsuiteAPIIdentityId = X'3AEE3082F5D74AFEBDEAA037526D9505';

SET @netsuiteResourceTypeId = (SELECT id FROM ResourceType WHERE code = 'customer-resource-assignment' AND domainId = @domainId);

SET @updateNetSuiteActionId = (SELECT id FROM ResourceAction WHERE code = 'read' AND resourceTypeId = @netsuiteResourceTypeId);

-- GRANT permission

INSERT INTO IdentityResourceAction (id, identityId, resourceActionId)

   (SELECT UNHEX(REPLACE(UUID(),'-','')), @netsuiteAPIIdentityId, @updateNetSuiteActionId

    WHERE NOT EXISTS(SELECT * FROM IdentityResourceAction WHERE identityId=@netsuiteAPIIdentityId AND resourceActionId=@updateNetSuiteActionId));