Oracle APEX — Basic authentication for REST services

Biljana Jelić
4 min readOct 10, 2019

To prevent unauthorized access to the REST services, Oracle Apex is providing a few various security methods. One of the easiest methods to implement is First-Party Authentication also known as “Basic authentication” which will be covered in this article.

In order to protect the REST services, a role, privilege, and assigned privilege to the service we want to protect need to be created. All these segments must work together to provide security.

The starting point will be to check Oracle Apex for all the created users and groups they are associated with, as well as the privileges of the same users and groups. It can be managed in the “Manage user and groups” section. If there are no existing users or groups, a specific group for REST services can be created so the users can be assigned to the created group. If there are already existing groups and users, the RESTful Service grant, from the “Group Assignments” list, needs to be added to the group. After creating a group and assigning a user to the group, privilege needs to be created and assigned to the created group. The user must be the member of a group which already has the privileges assigned. Also, while creating the privilege, protected modules need to be picked and added to the privilege.

There can be multiple groups as a part of…

--

--

Biljana Jelić
Biljana Jelić

Written by Biljana Jelić

SQL, SSMS, PL/SQL , Data migration, ETL, Oracle Apex, Python #techgirls

Responses (1)