Stored Procedures

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

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

CData Excel Add-In for Azure Active Directory Stored Procedures


Name	Description
ActivateDirectoryRole	Activates a directory role.
AddGroupApplicationRoleAssignment	Add group to an Application Role Assignment.
AddGroupMember	Adds a member to a group.
AddGroupOwner	Adds an owner to a group.
AddMember	Add member to a directory role.
AddPhoneAuthenticationMethod	Add a phone authentication method for a user.
AddPrivilegedRole	Add a privileged role for a user.
AddProfileCardProperty	Adds a new ProfileCardProperty for an organization.
AddUserApplicationRoleAssignment	Add user to an Application Role Assignment.
AssignLicense	Add or remove subscriptions for the user. You can also enable and disable specific plans associated with a subscription
AssignManager	Assign a user's manager.
ChangePassword	Change a user's password.
CheckMemberObjectsForUser	Check for membership in groups, administrative units, or directory roles for a user.
FetchAdditionalUserFields	Fetch all T1, T2, and T3 fields for a specified user.
GetAdminConsentURL	Gets the admin consent URL that an admin of a given domain must open separately to grant access to your application. Only needed when using custom OAuth credentials.
GetOAuthAccessToken	Gets an authentication token from AzureActiveDirectory.
GetOAuthAuthorizationURL	Gets the authorization URL that the user must open to grant access to your application. Only needed when developing Web apps. You request the auth token from this URL.
InviteExternalUser	Invite an external user to the organization.
PromoteDomain	Promotes a domain.
RefreshOAuthAccessToken	Refreshes the OAuth access token used for authentication with various Office 365 services.
RemoveGroupApplicationRoleAssignment	Removes a group from an Application Role Assignment.
RemoveGroupMember	Remove a member from a Group.
RemoveGroupOwner	Remove an owner from a Group.
RemoveManager	Remove a user's manager.
RemoveMember	Removes a member from a directory role.
RemovePhoneAuthenticationMethod	Remove a phone authentication method for a user.
RemovePrivilegedRole	Remove a privileged role for a user.
RemoveProfileCardProperty	Removes a ProfileCardProperty for an organization.
RemoveUserApplicationRoleAssignment	Remove a user from an Application Role Assignment.
RemoveUserPhoto	Remove the photo of a user.
ResetPassword	Reset a user's password.
RetrieveManagerChain	Retrieve a user's manager chain.
RetrieveUserPhoto	Retrieve the photo of a user.
UpdatePhoneAuthenticationMethod	Update a phone authentication method for a user.
UpdateUserPhoto	Update the photo of a user.
VerifyDomain	Verifies a domain.