Page History

...

1. In the newly added Access Policy, click Add Rule.
2. Enter a rule name.
3. Select the authorized Grant Types. You should select Resource Owner Password and Client Credentials along with any others that match your organization’s policies.
   Image RemovedImage Added
   Image RemovedImage Added

For scopes, you can select any of the scopes or select the desired scopes created earlier that clients assigned to this policy will be able to request (including offline_access for refresh tokens if needed). Configure any additional settings as needed.

Image RemovedImage Added

Click Create Rule.

To Verify:

Image RemovedImage Added

Collect Okta information

...

 external_oauth_snowflake_user_mapping_attribute = 'login_name'

Image RemovedImage Added

Generate Access Token:

...

curl -X POST -H "Content-Type: application/x-www-form-urlencoded;charset=UTF-8" \
 --user <OAUTH_CLIENT_ID>:<OAUTH_CLIENT_SECRET> \
 --data-urlencode "username=<OKTA_USER_USERNAME>" \
 --data-urlencode "password=<OKTA_USER_PASSWORD>" \
 --data-urlencode "grant_type=password" \
 --data-urlencode "scope=session:role:analyst" \
 <OKTA_OAUTH_TOKEN_ENDPOINT>

Configure the ODBC DSN:

Image RemovedImage Added

Add access token Registry Editor by following the below steps:

1. Press Win + R, type regedit, and press Enter.
2. Navigate to:
   Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\
3. Locate and select your DSN (Data Source Name).
4. Right-click in the right pane and select New > String Value.
5. Enter the appropriate field name and value, ensuring they match the required 
   configuration.

Image RemovedImage Added

Test the ODBC DSN:

Image RemovedImage Added