Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT/INSERT/UPDATE/DELETE operations with Okta.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Okta, along with an indication of whether the procedure succeeded or failed.
CData JDBC Driver for Okta Stored Procedures
| Name | Description |
| ActivateApp | Activates an inactive application. |
| ActivateDevice | Activates a device and sets its status to ACTIVE. |
| ActivateUser | Activates a user and sets its status to ACTIVE. Can only be performed on Users with a status of STAGED or DEPROVISIONED. |
| AssignGroupToApp | Assigns a group to an app, which also assigns all the app to the group's users. |
| AssignGroupToRole | Assigns a group to a role. |
| AssignUserToApp | Assigns a user to an app. |
| AssignUserToGroup | Assigns a user to a group with the OKTA_GROUP type. |
| AssignUserToRole | Assigns a user to a role. |
| DeactivateApp | Deactivates an active application. |
| DeactivateAuthenticator | Deactivates an authenticator. |
| DeactivateDevice | Deactivates a device and sets its status to DEACTIVATED. This removes all of its device user links. |
| DeactivateGroupRule | Deactivates a specified group rule. |
| DeactivateUser | Deactivates a user and sets its status to DEPROVISIONED. Can only be performed on Users that do not have a status DEPROVISIONED. |
| GetOAuthAccessToken | Gets an authentication token from Okta. |
| GetOAuthAuthorizationURL | Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. You will request the OAuthAccessToken from this URL. |
| ReactivateUser | Restarts the activation flow for a user and sets its status to ACTIVE. Can only be performed on Users with a status of RECOVERY or PROVISIONED. |
| RefreshOAuthAccessToken | Use this procedure to refresh the access token. |
| ResetPassword | Replaces the password for the current user. |
| ResetUserPassword | Resets a user's password and sets the user's status to RECOVERY. |
| RevokeApiToken | Revokes an API token. |
| SuspendDevice | Suspends a device and sets its status to SUSPENDED. |
| SuspendUser | Suspends a user and sets its status to SUSPENDED. Can only be performed on Users with a status of ACTIVE. |
| UnassignGroupToApp | Unassigns a group from an app. |
| UnassignGroupToRole | Unassigns a group from a role. |
| UnassignUserToApp | Unassigns a user from an app. |
| UnassignUserToGroup | Unassigns a user from a group with the OKTA_GROUP type. |
| UnassignUserToRole | Unassigns a user from a role. |
| UnlockUser | Unlocks a User with a LOCKED_OUT status or unlocks a User with an ACTIVE status that is blocked. Only works with Okta-sourced users. |
| UnsuspendDevice | Unsuspends a device and sets its status to ACTIVE. Can only be performed on devices with a status of SUSPENDED. |
| UnsuspendUser | Unsuspends a user and sets its status to ACTIVE. Can only be performed on Users with a status of SUSPENDED. |