alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;
alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited;

--book user-------------------------------------
BEGIN
EXECUTE IMMEDIATE 'DROP USER BOOK_USER cascade' ;
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE != -1918 THEN
RAISE;
END IF;
END;
/
-- USER SQL
CREATE USER BOOK_USER IDENTIFIED BY USER_Pa55w0rd;
GRANT create view TO BOOK_USER;

ALTER USER BOOK_USER QUOTA 25M ON DATA;


-- ADD ROLES
GRANT CONNECT TO BOOK_USER;
GRANT RESOURCE TO BOOK_USER;
ALTER USER BOOK_USER DEFAULT ROLE CONNECT,RESOURCE;

-- ENABLE REST
BEGIN
ORDS.ENABLE_SCHEMA(
p_enabled => TRUE,
p_schema => 'BOOK_USER',
p_url_mapping_type => 'BASE_PATH',
p_url_mapping_pattern => 'book_user',
p_auto_rest_auth=> TRUE
);
commit;
END;
/



--hudsonu-------------------------------------
BEGIN
EXECUTE IMMEDIATE 'DROP USER hudsonu cascade' ;
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE != -1918 THEN
RAISE;
END IF;
END;
/
CREATE USER hudsonu IDENTIFIED BY USER_Pa55w0rd;
ALTER USER hudsonu QUOTA 25M ON DATA;
-- ADD ROLES
GRANT CONNECT TO hudsonu;
GRANT RESOURCE TO hudsonu;
GRANT create view TO hudsonu;

ALTER USER hudsonu DEFAULT ROLE CONNECT,RESOURCE;

-- ENABLE REST
BEGIN
ORDS.ENABLE_SCHEMA(
p_enabled => TRUE,
p_schema => 'hudsonu',
p_url_mapping_type => 'BASE_PATH',
p_url_mapping_pattern => 'hudsonu',
p_auto_rest_auth=> TRUE
);
commit;
END;
/


--canvas user-------------------------------------
BEGIN
EXECUTE IMMEDIATE 'DROP USER CANVAS cascade' ;
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE != -1918 THEN
RAISE;
END IF;
END;
/



CREATE USER CANVAS IDENTIFIED BY USER_Pa55w0rd;

GRANT CONNECT TO CANVAS;
GRANT RESOURCE TO CANVAS;
GRANT create view 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;
/