启用ords

参考 https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-authentication

1
2
3
4



CREATE USER ED_TEST_001 IDENTIFIED BY ">T>}Mc)j(64jRJm)Yy0y";
GRANT CREATE SESSION TO ED_TEST_001;
GRANT SELECT ON apex_dev.emp TO ED_TEST_001;  

以 ED_TEST_001 身份登录, 执行以下语句.开启web访问

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11



BEGIN
  ORDS.enable_schema(
    p_enabled             => TRUE,
    p_schema              => 'ED_TEST_001',
    p_url_mapping_type    => 'BASE_PATH',
    p_url_mapping_pattern => 'hr',
    p_auto_rest_auth      => FALSE
  );
  COMMIT;
END;