SHOW AVAILABLE ORGANIZATION PROFILES¶

列出用户的组织中可用的组织配置文件。

See also:: ALTER ORGANIZATION PROFILE, CREATE ORGANIZATION PROFILE, DESCRIBE AVAILABLE ORGANIZATION PROFILE, DESCRIBE ORGANIZATION PROFILE, DROP ORGANIZATION PROFILE, SHOW ORGANIZATION PROFILES, SHOW VERSIONS IN ORGANIZATION PROFILE

语法

SHOW AVAILABLE ORGANIZATION PROFILES

输出

命令的输出包括以下列，它们描述了对象的属性和元数据：

Column	Description
`created_on`	The date and time when the organization profile was created.
`name`	The name of the organization profile.
`system_generated`	Indicates the organization profile is system generated.
`state`	The organization profile state. One of ACTIVE or DRAFT.
`organization_name`	The name of the organization associated with the organization profile.
`title`	The title of the organization profile.
`description`	The description of the organization profile.
`owner_contact`	The contact email of the owner of the organization profile.
`approver_contact`	The contact email of the access approver of the organization profile.
`can_publish_listings_with_profile`	Whether the current user can publish organizational listings using this organization profile. One of `TRUE` or `FALSE`.

示例

以下示例列出了您有权访问的组织配置文件：

SHOW AVAILABLE ORGANIZATION PROFILES;

+-------------------------+-------------+---------------------+---------------------+---------------------+------------------------+---------------------------------+---------------------+---------------------+-----------------------------------+
|created_on               |name         |system_generated     |state                |organization_name    |title                   |description                      |owner_contact        |approver_contact     |can_publish_listings_with_profile  |
+-------------------------+-------------+---------------------+---------------------+---------------------+------------------------+---------------------------------+---------------------+---------------------+-----------------------------------+
|2025-01-01 01:01:01.000  |ORGPROFILE   |FALSE                |ACTIVE               |TESTORG              |My Organization Profile |Organization profile description |test@test.com        |test@test.com        |TRUE                               |
+-------------------------+-------------+---------------------+---------------------+---------------------+------------------------+---------------------------------+---------------------+---------------------+-----------------------------------+