Enable User Access

Buğra PARLAYAN

12 months ago

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.

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;

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.