Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article, we will be explaining How to Enable User Access to SQL Developer Web.
Oracle SQL Developer Web works with Oracle REST data and schemas are based on some user authentication.
However, the ADMIN user needs to enable you to log in to Oracle SQL Developer Web.
When we run the code block below with the ADMIN user, the relevant user will be entitled to log in.
1 2 3 4 5 6 7 8 9 10 | BEGIN ords_admin.enable_schema( p_enabled => TRUE, p_schema => 'schema-name', p_url_mapping_type => 'BASE_PATH', p_url_mapping_pattern => 'schema-alias', p_auto_rest_auth => NULL ); commit; END; |
schema-name = Specifies the schema to link to. All must be written in capital letters.
schema-alias = Used to give alias to the schema to be linked. For security reasons, Oracle recommends using alias.
