Create Student Account on Oracle
alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;
alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited;
CREATE USER STUDENT IDENTIFIED BY Temporary_Password_1234;
-- ADD ROLES
GRANT CONNECT TO STUDENT;
GRANT RESOURCE TO STUDENT;
GRANT CREATE VIEW TO STUDENT;
ALTER USER STUDENT DEFAULT ROLE CONNECT,RESOURCE;
ALTER USER STUDENT QUOTA 100M ON DATA;
-- ENABLE REST
BEGIN
ORDS.ENABLE_SCHEMA(
p_enabled => TRUE,
p_schema => 'STUDENT',
p_url_mapping_type => 'BASE_PATH',
p_url_mapping_pattern => 'student',
p_auto_rest_auth=> TRUE
);
commit;
END;
/
ALTER USER STUDENT IDENTIFIED BY Y0UR_new_Password;