curl

curl -X POST https://my_sql_node.com/v1/sso_device_grant \
    -H "Content-Type: application/json" \
    -d '{
        "database": "retail_analytics"
    }'

{
  "verification_uri_complete": "https://auth.example.com/device?code=BCDFGHJK",
  "verification_uri": "https://auth.example.com/device",
  "user_code": "BCDFGHJK",
  "status": {
    "reason": "Device authorization initiated",
    "sql_state": "00000",
    "vendor_code": 0
  }
}

Ocient HTTP Query API

sso_device_grant

Retrieve an OpenID device grant code that the Ocient System can verify and use with the sso_device_grant_verify endpoint.

The device grant process is intended for devices with limited input capabilities or no web browser:

Call this endpoint to retrieve a user code and verification URI.
Display the user code and verification URI to the user.
The user visits the verification URI on another device and enters the code.
Call the sso_device_grant_verify endpoint to check if the user has completed verification.

POST

sso_device_grant

curl

curl -X POST https://my_sql_node.com/v1/sso_device_grant \
    -H "Content-Type: application/json" \
    -d '{
        "database": "retail_analytics"
    }'

{
  "verification_uri_complete": "https://auth.example.com/device?code=BCDFGHJK",
  "verification_uri": "https://auth.example.com/device",
  "user_code": "BCDFGHJK",
  "status": {
    "reason": "Device authorization initiated",
    "sql_state": "00000",
    "vendor_code": 0
  }
}

Body

application/json

database

string

Target database name. If you do not specify this parameter, the request defaults this value to system. This value represents the database where the user connects after completing the device grant process.

Response

200 - application/json

Response

verification_uri_complete

string

verification_uri

string

user_code

string

status

object

Show child attributes

Last modified on May 20, 2026

sso_token sso_device_grant_verify

⌘I