List of Figures
- 1-1 Connecting to the Database as an Administrator or an User with DBA Role
- 1-2 ORDSTEST User with required Privileges, Roles, and Tablespace
- 1-3 Executing the ORDS.ENABLE_SCHEMA PL/SQL Procedure
- 1-4 ORDS.ENABLE_SCHEMA PL/SQL Procedure
- 1-5 Accessing Database Actions as the ORDSTEST User
- 1-6 Database Actions Launchpad
- 1-7 Selecting SQL Worksheet
- 1-8 Auto REST-enabling the EMP table
- 1-9 REST Enable Object Screen
- 1-10 Table REST-enabled Confirmation
- 1-11 Icon showing Database Object is Auto REST-enabled
- 1-12 Locating Curl Command to Test the Rest Endpoint
- 1-13 Results Atfer Testing the Emp URL in the Browser
- 1-14 Navigating to the REST Workshop from the Launchpad
- 1-15 Modules Dashboard
- 1-16 Entering Values in the Create Module Screen
- 1-17 Create Template Screen
- 1-18 Create Handler
- 1-19 Resource handler SQL query results
- 1-20 New Tab for Testing the Endpoint
- 1-21 JSON Response from GET Method
- 1-22 Selecting Privileges Menu Option
- 1-23 Associating Resource Module with the Privilege
- 1-24 Privilege Created
- 1-25 Navigating to the demo module to Test the Privilege
- 1-26 Copying the URI to Test the Privilege
- 1-27 Sign-in to Test Path Privilege
- 1-28 Navigating to OAuth Client Menu Option
- 1-29 Create OAuth Client
- 1-30 Checking Client Credentials Selected
- 1-31 Entering Values in Create OAuth Client Slider
- 1-32 Move Privilege to Selected Column
- 1-33 OAuth Client Created
- 1-34 Selecting Correct Shell Environment
- 1-35 Access Token with Expiration
- 1-36 jq Response from the Get Request
- 1-37 Enabling the Schema of the EMP Table for REST
- 1-38 REST Enabling the EMP Table
- 1-39 Testing the REST Enabled Table
- 1-40 REST Data Services option under Connections Navigator
- 1-41 Entering Information on the Specify Module Page
- 1-42 Entering Information on the Specify Template Page
- 1-43 Entering Information on Create Resource Handler Page:
- 1-44 Testing URL in a Web Browser
- 1-45 Create Privilege Dialog Box
- 1-46 JSON Document After Signing in
- 1-47 Entering the New Role Name
- 1-48 Entering Information for New RESTful Services Connection
- 1-49 Entering Information on the Specify Module Page
- 1-50 Entering Information on the Specify Template Page
- 1-51 Entering Information on the Specify Handler Page:
- 1-52 Testing the RESTful Service Created from a SQL Query
- 1-53 Edit Privilege Dialog Box