server_trust_groups

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

Overview

Name	server_trust_groups
Type	Resource
Id	azure.sql.server_trust_groups

Fields

vw_server_trust_groups

Name	Datatype	Description
group_members	text	field from the properties object
locationName	text	field from the properties object
resourceGroupName	text	field from the properties object
serverTrustGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
trust_scopes	text	field from the properties object

server_trust_groups

Name	Datatype	Description
properties	object	Properties of a server trust group.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	locationName, resourceGroupName, serverTrustGroupName, subscriptionId	Gets a server trust group.
list_by_location	SELECT	locationName, resourceGroupName, subscriptionId	Lists a server trust group.
create_or_update	INSERT	locationName, resourceGroupName, serverTrustGroupName, subscriptionId	Creates or updates a server trust group.
delete	DELETE	locationName, resourceGroupName, serverTrustGroupName, subscriptionId	Deletes a server trust group.

SELECT examples

Lists a server trust group.

vw_server_trust_groups

SELECT
group_members,
locationName,
resourceGroupName,
serverTrustGroupName,
subscriptionId,
trust_scopes
FROM azure.sql.vw_server_trust_groups
WHERE locationName = '{{ locationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

server_trust_groups

SELECT
properties
FROM azure.sql.server_trust_groups
WHERE locationName = '{{ locationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.sql.server_trust_groups (
locationName,
resourceGroupName,
serverTrustGroupName,
subscriptionId,
properties
)
SELECT 
'{{ locationName }}',
'{{ resourceGroupName }}',
'{{ serverTrustGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: groupMembers
          value:
            - - name: serverId
                value: string
        - name: trustScopes
          value:
            - string

DELETE example

Deletes the specified server_trust_groups resource.

/*+ delete */
DELETE FROM azure.sql.server_trust_groups
WHERE locationName = '{{ locationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverTrustGroupName = '{{ serverTrustGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';