Stored Procedures

ストアドプロシージャはファンクションライクなインターフェースで、Azure Active Directory の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにAzure Active Directory から関連するレスポンスデータを返します。

CData SSIS Components for Azure Active Directory Stored Procedures


Name	Description
ActivateDirectoryRole	Activates a specified directory role for use within the Azure AD environment.
AddGroupApplicationRoleAssignment	Adds a group to an application role assignment, granting specific permissions to the group.
AddGroupMember	Adds a user or entity to a specified group within the organization.
AddGroupOwner	Assigns an owner to a group, providing management permissions.
AddMember	Adds a member to a specified directory role within Azure AD.
AddPhoneAuthenticationMethod	Configures and adds a new phone-based authentication method for a user.
AddPrivilegedRole	Assigns a privileged role to a user, enabling elevated permissions.
AddProfileCardProperty	Adds a custom property to user profile cards for enhanced organizational visibility.
AddUserApplicationRoleAssignment	Assigns a user to an application role for access and permissions management.
AssignLicense	Manages user subscriptions and service plans by adding or removing licenses.
AssignManager	Assigns a manager to a user, establishing organizational hierarchy.
ChangePassword	Updates a user's password, enhancing account security.
CheckMemberObjectsForUser	Verifies membership details for a user across groups, administrative units, and directory roles.
FetchAdditionalUserFields	Retrieves additional user-defined fields (T1, T2, T3) for a specific user.
GetAdminConsentURL	Generates an admin consent URL for granting application permissions within a domain.
GetOAuthAccessToken	Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to Azure Active Directory.
GetOAuthAuthorizationURL	Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process.
InviteExternalUser	Invites an external user to join the organization with specified access permissions.
PromoteDomain	Promotes a domain to a verified state within the Azure AD environment.
RefreshOAuthAccessToken	Refreshes an expired OAuth Access Token to maintain continuous authenticated access to Azure Active Directory resources without requiring reauthorization from the user.
RemoveGroupApplicationRoleAssignment	Removes a group from an application role assignment, revoking specific permissions.
RemoveGroupMember	Removes a member from a specified group within the organization.
RemoveGroupOwner	Revokes ownership rights from a group owner.
RemoveManager	Unassigns a manager from a user, altering the organizational hierarchy.
RemoveMember	Removes a member from a specified directory role within Azure AD.
RemovePhoneAuthenticationMethod	Removes a phone-based authentication method for a user.
RemovePrivilegedRole	Revokes a privileged role from a user, removing elevated permissions.
RemoveProfileCardProperty	Removes a custom property from user profile cards.
RemoveUserApplicationRoleAssignment	Revokes a user's application role assignment, removing access.
RemoveUserPhoto	Deletes a user's profile photo from the directory.
ResetPassword	Resets a user's password to regain access or enhance security.
RetrieveManagerChain	Fetches the reporting hierarchy for a user, detailing their manager chain.
RetrieveUserPhoto	Retrieves a user's profile photo for display or verification purposes.
UpdateMFAStatus	Updates the per-user multifactor authentication state for a user.
UpdatePhoneAuthenticationMethod	Updates an existing phone-based authentication method for a user.
UpdateUserPhoto	Updates a user's profile photo in the directory.
VerifyDomain	Verifies the ownership of a domain within the Azure AD environment.