SQL DEVELOPER WEB – approaching off the bow

IT by javier mugueta25 September, 201912 February, 2020

Oracle Autonomous Database: Configuring SQL Developer Web Access for Database Users

Connect to SQL Developer Web as admin user Create a new user, give privileges quotas and the like… create user MYUSER identified by “xxxxxxxxx”; grant connect to MYUSER; GRANT DWROLE TO MYUSER; execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA(‘MYUSER’,’1G’); BEGIN ORDS_ADMIN.ENABLE_SCHEMA(p_enabled => TRUE,p_schema => ‘MYUSER’, p_url_mapping_type => ‘BASE_PATH’, p_url_mapping_pattern =>’MYUSER’, p_auto_rest_auth => TRUE); COMMIT; END; / Copy the link of […]