Script to add user to SQL Dev Web

[martindsouza]

Thanks to @fuzziebrain for pointing out that schemas either need to be mapped to an APEX workspace or explicit access needs to be granted to them to access SQL Dev Web.

• Create a script based on https://fuzziebrain.com/content/id/1919/

begin
  ords_admin.enable_schema(
    p_enabled => true
    , p_schema => 'GRE'
    , p_url_mapping_type => 'BASE_PATH'
    , p_url_mapping_pattern => 'gre'
    , p_auto_rest_auth => null
  );
  
  commit;
end;

This could be a script we provide here and suggest to run via sqlcl (via raw URL)