ORACLE AUTONOMOUS DATABASE

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 […]

More