Through XQuery

To set up OAuth-based authentication and authorization with Microsoft Entra using XQuery through the Query Console, follow these steps:

1. Create the external security object by executing code like this:

   Note:
   
   The JWT Secrets field secures both symmetric and asymmetric signature keys.

   Note:
   
   You can specify a JWKS URI to validate incoming JWT access tokens with JWKS instead of with JWT Secrets signature keys.

   Note:
   
   The parameters $oauth-authorization-server-uri, $oauth-token-server-uri, $oauth-redirect-uri, $oauth-scope, $oauth-client-authentication-method, and $oauth-client-secret are required only when using the Authorization code flow. These parameters configure the MarkLogic app server to act as an OAuth client. They are not needed for the Resource server flow.

   Resource server flow

   Copy

   xquery version "1.0";
   import module namespace sec = "http://marklogic.com/xdmp/security" at "/MarkLogic/security.xqy";
   
   let $oauth-vendor := "Microsoft Entra",
   $oauth-flow-type := "Resource server",
   $oauth-client-id := "37b06574-bdf0-42a2-9659-ebeaf8faf1c6",
   $oauth-token-type := "JSON Web Tokens",
   $oauth-username-attribute := "name",
   $oauth-role-attribute := "groups",
   $oauth-jwt-issuer-uri := "https://sts.windows.net/3fc33f01-1894-4196-b81f-54417daac155/",
   $oauth-privilege-attribute := "",
   $oauth-jwt-alg := "RS256",
   $oauth-jwt-key-ids := "XRvko8P7A3UaWSnU7bM9nT0MjhA",
   $oauth-jwt-secret-values := "-----BEGIN PUBLIC KEY-----<Insert PEM-converted RS256 JWT Secret Value>-----END PUBLIC KEY-----",
   
   $oauth-jwks-uri := ""
   
   let $oauth := sec:oauth-server(
   $oauth-vendor,
   $oauth-flow-type,
   $oauth-client-id,
   $oauth-token-type, 
   $oauth-username-attribute,
   $oauth-role-attribute,
   $oauth-privilege-attribute,
   $oauth-jwt-issuer-uri,
   $oauth-jwt-alg,
   $oauth-jwt-key-ids,
   $oauth-jwt-secret-values)
   
   return sec:create-external-security(
   'MicrosoftEntraExampleOAuth',
   'Microsoft Entra external security object for OAuth',
   'oauth',
   300,
   'oauth',
   (),
   (),
   $oauth)
   

   Authorization code flow

   Copy

   xquery version "1.0";
   import module namespace sec = "http://marklogic.com/xdmp/security" at "/MarkLogic/security.xqy";
   
   let $oauth-vendor := "Microsoft Entra",
   $oauth-flow-type := "Authorization code",
   $oauth-client-id := "<application-client-id>",
   $oauth-token-type := "JSON Web Tokens",
   $oauth-username-attribute := "name",
   $oauth-role-attribute := "groups",
   $oauth-jwt-issuer-uri := "<jwt-issuer-uri>",
   $oauth-privilege-attribute := "",
   $oauth-jwt-alg := "RS256",
   $oauth-jwt-key-ids := "<key-id>",
   $oauth-jwt-secret-values := "-----BEGIN PUBLIC KEY-----<PEM-converted key>-----END PUBLIC KEY-----",
   $oauth-jwks-uri := "",
   $oauth-authorization-server-uri := "<oauth-server-authorize-endpoint>",
   $oauth-token-server-uri := "<oauth-server-token-endpoint>",
   $oauth-redirect-uri := "https://<marklogic-host>:<app-server-port>",
   $oauth-scope := "openid profile",
   $oauth-client-authentication-method := "Client secret",
   $oauth-client-secret := "<client-secret-value>"
   
   let $oauth := sec:oauth-server(
   $oauth-vendor,
   $oauth-flow-type,
   $oauth-client-id,
   $oauth-token-type,
   $oauth-username-attribute,
   $oauth-role-attribute,
   $oauth-privilege-attribute,
   $oauth-jwt-issuer-uri,
   $oauth-jwt-alg,
   $oauth-jwt-key-ids,
   $oauth-jwt-secret-values,
   $oauth-jwks-uri,
   $oauth-authorization-server-uri,
   $oauth-token-server-uri,
   $oauth-redirect-uri,
   $oauth-scope,
   $oauth-client-authentication-method,
   $oauth-client-secret)
   
   return sec:create-external-security(
   'MicrosoftEntraExampleOAuthClient',
   'Microsoft Entra external security object for OAuth Authorization Code flow',
   'oauth',
   300,
   'oauth',
   (),
   (),
   $oauth)
   

2. Create any HTTP, XDBC, WebDAV, or ODBC app servers that you wish to configure with this external security object.

3. Configure your app servers to use this external security object with code like this:

   Copy

   xquery version "1.0-ml";
   import module namespace admin = "http://marklogic.com/xdmp/admin" at "/MarkLogic/admin.xqy";
   
   let $config := admin:get-configuration()
   let $groupid := admin:group-get-id($config, "Default")
   let $appserver := <app server name>
   let $extsec := "MicrosoftEntraExampleOAuth"
   
   return admin:save-configuration(admin:appserver-set-external-security($config, admin:appserver-get-id($config, $groupid, $appserver), $extsec, fn:false(), "oauth"))
   

4. Assign external names to your desired roles with code like this:

   Copy

   xquery version "1.0-ml";
   import module namespace sec = "http://marklogic.com/xdmp/security" at "/MarkLogic/security.xqy";
   
   let $role-name := <MarkLogic Server role name like "manage-user">
   let $external-name := "7228762e-cb30-428a-ae1a-3a8cf9e2f728"
   return sec:role-set-external-names($role-name, $external-name)
   

MarkLogic Server is now set up for OAuth-based authentication and authorization with Microsoft Entra.