To use Stripe with Autonomous Database, set Network ACL for accessing Stripe and create a credential that allows access to Stripe.

1. Use the DBMS_NETWORK_ACL_ADMIN package to set Network ACL for accessing Stripe.

   BEGIN   
       DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
            host => 'stripe.com',
            ace  => xs$ace_type(privilege_list => xs$name_list('http'),
                                principal_name => 'FOO',
                                principal_type => xs_acl.ptype_db)
      );
   END;
   /

2. Only an ADMIN has access to the Stripe Views. A user must be granted READ access to use them.
   For Example:

   GRANT READ on STRIPE_COUPONS to TYLER;

3. Create a Credential for Stripe APIs. There are two ways to perform this task:
   • (Option 1: Create a credential object with the name STRIPE$CRED.) The username is STRIPE_TOKEN and the password is the Stripe API token. This token can be found in the Stripe Developers Dashboard. See Stripe API keys for additional information.

     BEGIN
         DBMS_CLOUD.CREATE_CREDENTIAL(
             credential_name => 'STRIPE$CRED',
             username        => 'STRIPE_TOKEN',
             password        => 'bearer_token' );
     END;
     /

   • (Option 2: Create a credential object with a user defined name.) The username is STRIPE_TOKEN and the password is the Stripe API token. This token can be found in the Stripe Developers Dashboard. Before selecting from the Stripe Views, the Session parameter DEFAULT_CREDENTIAL should be set using the owner and credential object name. See Stripe API keys for additional information.

     BEGIN  
         DBMS_CLOUD.CREATE_CREDENTIAL(
             credential_name => 'MY_STRIPE_CRED',
             username        => 'STRIPE_TOKEN',
             password        => 'bearer_token');
     END;
     /
     ALTER SESSION SET default_credential = 'MY_SCHEMA.MY_STRIPE_CRED';

4. Test by querying a Stripe View:

   SELECT name, percent_off, duration, times_redeemed FROM STRIPE_COUPONS;
   
   NAME              PERCENT_OFF DURATION        TIMES_REDEEMED
   --------------- ------------- --------------- --------------
   Promotion Feb           10.00 once                         0
   Seasonal disc            5.00 once                         0
   Firstpurchase            5.00 forever                      1

STRIPE_ACCOUNTS lists the Stripe account information for the authenticated caller.

STRIPE_COUPONS lists the coupons issued in the Stripe account.

STRIPE_CUSTOMERS lists the customers defined in the Stripe account.

STRIPE_INVOICES lists the invoices defined in the Stripe account.

STRIPE_PLANS lists the pricing plans defined in the Stripe account.

STRIPE_PRODUCTS lists the query information about products defined in the Stripe account.

STRIPE_SUBSCRIPTIONS lists the subscriptions managed in the Stripe account.