Database
|
Query to be Added
|
Oracle database
|
CREATE TABLE <E3C_Schema_Name>.OAUTH_CLIENT_TOKEN
( TOKEN BLOB, AUTHENTICATION_ID varchar(256) PRIMARY KEY NOT NULL ); |
MS SQL database
|
CREATE TABLE <E3C_Schema_Name>.[OAUTH_CLIENT_TOKEN](
[TOKEN] [image] NULL, [AUTHENTICATION_ID] [nvarchar](255) NOT NULL, CONSTRAINT [OAUTH_CLIENT_TOKEN_PK2] PRIMARY KEY ( [AUTHENTICATION_ID] ASC )) |
PostgreSQL database
|
CREATE TABLE <E3C_Schema_Name>.oauth_client_token
( token bytea, authentication_id character varying(255) NOT NULL PRIMARY KEY ); |
|
It is assumed that you are familiar with SSO using SAML authentication and delegated authorization (OAuth).
PTC Arbortext Content Delivery supports the SAML 2.0 protocol for user authentication and OAuth 2.0 protocol for delegated authorization.
|