BEGIN
EXECUTE IMMEDIATE 'DROP USER CANVAS cascade' ;
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE != -1918 THEN
RAISE;
END IF;
END;
/
alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;
alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited;
CREATE USER CANVAS IDENTIFIED BY USER_Pa55w0rd;
GRANT CONNECT TO CANVAS;
GRANT RESOURCE TO CANVAS;
ALTER USER CANVAS QUOTA 25M ON DATA;
-- ENABLE REST
BEGIN
ORDS.ENABLE_SCHEMA(
p_enabled => TRUE,
p_schema => 'CANVAS',
p_url_mapping_type => 'BASE_PATH',
p_url_mapping_pattern => 'canvas',
p_auto_rest_auth=> TRUE
);
commit;
END;
/