Oracle Report User
DROP USER REPORTS CASCADE;
-- USER SQL
CREATE USER REPORTS IDENTIFIED BY Anti_Theft_99;
-- ADD ROLES
GRANT CONNECT TO REPORTS;
GRANT RESOURCE TO REPORTS;
ALTER USER REPORTS DEFAULT ROLE CONNECT,RESOURCE;
ALTER USER REPORTS QUOTA UNLIMITED on DATA;
-- ENABLE REST
BEGIN
ORDS.ENABLE_SCHEMA(
p_enabled => TRUE,
p_schema => 'REPORTS',
p_url_mapping_type => 'BASE_PATH',
p_url_mapping_pattern => 'reports',
p_auto_rest_auth=> TRUE
);
commit;
END;
/
grant select on canvas.ARTIST to reports;
grant select on canvas.ARTIST_POSTS to reports;
grant select on canvas.IMAGE to reports;
grant select on canvas.IMAGE_POSTS to reports;
grant select on canvas.MUSEUM to reports;
grant select on canvas.MUSEUM_HOURS to reports;
grant select on canvas.SUBJECT to reports;
grant select on canvas.WORK to reports;