Oracle Autonomous Database: Configuring SQL Developer Web Access to 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 “xxxxxxxxxx“;
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 )

Google photo

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

Twitter picture

You are commenting using your Twitter 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.