-- ADD ROLES
GRANT CONNECT TO HUDSON_USER;
GRANT RESOURCE TO HUDSON_USER;
ALTER USER HUDSON_USER DEFAULT ROLE CONNECT,RESOURCE;
-- ENABLE REST
BEGIN
ORDS.ENABLE_SCHEMA(
p_enabled => TRUE,
p_schema => 'HUDSON_USER',
p_url_mapping_type => 'BASE_PATH',
p_url_mapping_pattern => 'hudson_user',
p_auto_rest_auth=> TRUE
);
commit;
END;
/
GRANT CONNECT TO HUDSON_USER;
GRANT RESOURCE TO HUDSON_USER;
ALTER USER HUDSON_USER DEFAULT ROLE CONNECT,RESOURCE;
-- ENABLE REST
BEGIN
ORDS.ENABLE_SCHEMA(
p_enabled => TRUE,
p_schema => 'HUDSON_USER',
p_url_mapping_type => 'BASE_PATH',
p_url_mapping_pattern => 'hudson_user',
p_auto_rest_auth=> TRUE
);
commit;
END;
/