オラクルの公式ブログにて、製品マネージャのTodd BottgerさんがAutonomous Databaseが提供しているツールにアクセスするURLの一覧を載せています。こちらの記事になります。
Oracle Autonomous Database Vanity URLs Part 3: Blocking ORDS-Provided Developer and Administrator Toolsブロックする対象：/sql-developer (末尾一致)
ブロックする対象：/sign-in/ (末尾一致)
ブロックする対象：/signed-out/ (末尾一致)
ブロックする対象：/sign-in/session (末尾一致)
ブロックする対象：/_/sql (末尾一致)
https://[エンドポイント名]/ords/[REST別名]/_/sql
% curl -X POST https://エンドポイント名/ords/admin/_/sql --user ユーザー名:パスワード --header "Content-Type: application/sql" --data $'SELECT * FROM DUAL'
{"env":{"defaultTimeZone":"UTC"},"items":[{"statementId":1,"statementType":"query","statementPos":{"startLine":1,"endLine":2},"statementText":"SELECT * FROM DUAL","resultSet":{"metadata":[{"columnName":"DUMMY","jsonColumnName":"dummy","columnTypeName":"VARCHAR2","precision":1,"scale":0,"isNullable":1}],"items":[{"dummy":"X"}],"hasMore":false,"limit":10000,"offset":0,"count":1},"response":[],"result":0}]}% %
ブロックする対象：/ords/<schema-name>/_sdw/ (先頭一致)
ブロックする対象：/ords/_/db-api/ (先頭一致)
https://[エンドポイント名]/ords/_/db-api/metadata-catalog/
% curl https://エンドポイント名/ords/_/db-api/stable/metadata-catalog/
{"items":[{"name":"default","links":[{"rel":"canonical","href":"https://エンドポイント名/ords/_/db-api/stable/metadata-catalog/openapi.json","mediaType":"application/vnd.oai.openapi+json;version=3.0"}]}],"links":[{"rel":"self","href":"https://エンドポイント名/ords/_/db-api/stable/metadata-catalog/"},{"rel":"describes","href":"https://エンドポイント名/ords/_/db-api/stable/"}]}
%
ブロックする対象：/ords/<schema-name>/_/db-api/ (先頭一致)
% curl --user ユーザー名:パスワード https://エンドポイント名/ords/admin/_/db-api/stable/database/objects/tables/\?limit=1
{"items":[{"owner":"SYS","table_name":"IND$","tablespace_name":"SYSTEM","cluster_name":"C_OBJ#","iot_name":null,"status":"VALID","pct_free":0,"pct_used":0,"ini_trans":0,"max_trans":0,"initial_extent":139264,"next_extent":204800,"min_extents":1,"max_extents":2147483645,"pct_increase":null,"freelists":1,"freelist_groups":1,"logging":"YES","backed_up":"N","num_rows":4361,"blocks":3131,"empty_blocks":0,"avg_space":0,"chain_cnt":0,"avg_row_len":94,"avg_space_freelist_blocks":0,"num_freelist_blocks":0,"degree":" 1","instances":" 1","cache":" N","table_lock":"ENABLED","sample_size":4361,"last_analyzed":"2022-03-02T06:35:56Z","partitioned":"NO","iot_type":null,"temporary":"N","secondary":"N","nested":"NO","buffer_pool":"DEFAULT","flash_cache":"DEFAULT","cell_flash_cache":"DEFAULT","row_movement":"DISABLED","global_stats":"YES","user_stats":"NO","duration":null,"skip_corrupt":"DISABLED","monitoring":"YES","cluster_owner":"SYS","dependencies":"DISABLED","compression":"DISABLED","compress_for":null,"dropped":"NO","read_only":"NO","segment_created":"YES","result_cache":"DEFAULT","clustering":"NO","activity_tracking":null,"dml_timestamp":null,"has_identity":"NO","container_data":"NO","inmemory":"DISABLED","inmemory_priority":null,"inmemory_distribute":null,"inmemory_compression":null,"inmemory_duplicate":null,"default_collation":"USING_NLS_COMP","duplicated":"N","sharded":"N","external":"NO","hybrid":"NO","cellmemory":null,"containers_default":"NO","container_map":"NO","extended_data_link":"NO","extended_data_link_map":"NO","inmemory_service":null,"inmemory_service_name":null,"container_map_object":"NO","memoptimize_read":"DISABLED","memoptimize_write":"DISABLED","has_sensitive_column":"NO","admit_null":"NO","data_link_dml_enabled":"NO","logical_replication":"ENABLED","staging":"NO","row_change_tracking":"NO","links":[{"rel":"self","href":"https://エンドポイント名/ords/admin/_/db-api/stable/database/objects/tables/SYS,IND%24"}]}],"hasMore":true,"limit":1,"offset":0,"count":1,"links":[{"rel":"self","href":"https://エンドポイント名/ords/admin/_/db-api/stable/database/objects/tables/"},{"rel":"describedby","href":"https://エンドポイント名/ords/admin/_/db-api/stable/metadata-catalog/"},{"rel":"first","href":"https://エンドポイント名/ords/admin/_/db-api/stable/database/objects/tables/?limit=1"},{"rel":"next","href":"https://エンドポイント名/ords/admin/_/db-api/stable/database/objects/tables/?offset=1&limit=1"}]}
%
ブロックする対象：/ords/<schema-name>/soda/ (先頭一致)
% curl --user ユーザー名:パスワード https://エンドポイント名/ords/admin/soda/latest
{"items":[],"hasMore":false}%
ブロックする対象：/_/public-properties/ (末尾一致)
% curl https://エンドポイント名/ords/admin/_/public-properties/
{"items":[],"count":0,"hasMore":false}
%
ブロックする対象：/ords/<schema-name>/_adp (先頭一致)
