server_azure_ad_administrators

Creates, updates, deletes, gets or lists a server_azure_ad_administrators resource.

Overview

Name	server_azure_ad_administrators
Type	Resource
Id	azure.sql.server_azure_ad_administrators

Fields

vw_server_azure_ad_administrators

Name	Datatype	Description
administratorName	text	field from the properties object
administrator_type	text	field from the properties object
azure_ad_only_authentication	text	field from the properties object
login	text	field from the properties object
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
sid	text	field from the properties object
subscriptionId	text	field from the properties object
tenant_id	text	field from the properties object

server_azure_ad_administrators

Name	Datatype	Description
properties	object	Properties of a active directory administrator.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	administratorName, resourceGroupName, serverName, subscriptionId	Gets a Azure Active Directory administrator.
list_by_server	SELECT	resourceGroupName, serverName, subscriptionId	Gets a list of Azure Active Directory administrators in a server.
create_or_update	INSERT	administratorName, resourceGroupName, serverName, subscriptionId	Creates or updates an existing Azure Active Directory administrator.
delete	DELETE	administratorName, resourceGroupName, serverName, subscriptionId	Deletes the Azure Active Directory administrator with the given name.

SELECT examples

Gets a list of Azure Active Directory administrators in a server.

vw_server_azure_ad_administrators

SELECT
administratorName,
administrator_type,
azure_ad_only_authentication,
login,
resourceGroupName,
serverName,
sid,
subscriptionId,
tenant_id
FROM azure.sql.vw_server_azure_ad_administrators
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

server_azure_ad_administrators

SELECT
properties
FROM azure.sql.server_azure_ad_administrators
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new server_azure_ad_administrators resource.

All Properties

/*+ create */
INSERT INTO azure.sql.server_azure_ad_administrators (
administratorName,
resourceGroupName,
serverName,
subscriptionId,
properties
)
SELECT 
'{{ administratorName }}',
'{{ resourceGroupName }}',
'{{ serverName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: administratorType
          value: string
        - name: login
          value: string
        - name: sid
          value: string
        - name: tenantId
          value: string
        - name: azureADOnlyAuthentication
          value: boolean

DELETE example

Deletes the specified server_azure_ad_administrators resource.

/*+ delete */
DELETE FROM azure.sql.server_azure_ad_administrators
WHERE administratorName = '{{ administratorName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';