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 SQL Developer Web

Change the /admin/ part of the url with the alias MYUSER for example

https://<estonoteloenseño>.oraclecloudapps.com/ords/MYUSER/_sdw/?nav=worksheet

That’s all folks! Hope it helps! 🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.