Excel Add-In for Google Directory

Build 24.0.9062

Roles

Lists roles in a domain.

Table Specific Information

Select

To get a list of all the roles, the CustomerId column is required. It can be set in the connection string or in the WHERE clause condition. If not specified, the CustomerId of the current account will be used.

For example, the following query is processed server side by the Google Directory APIs:

SELECT * FROM Roles

Columns

Name Type Description
Id [KEY] String The unique identifier for the role.
Name String Name of the role.
Description String A short description of the role.
PrivilegeName String The name of the privilege.
ServiceId String The ID of the service the privilege is for.
IsSystemRole Boolean Indicates if it is a pre-defined system role.
IsSuperAdminRole Boolean Indicates if the role is a super admin role.
Etag String Etag of the resource.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
CustomerId String Id of the customer

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062