SHOW ORGANIZATION PROFILES¶

列出您有权访问的组织配置文件。

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

语法

SHOW ORGANIZATION PROFILES

输出

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

Column	Description
`created_on`	The date and time when the organization profile was created.
`name`	The organization profile name.
`system_generated`	Indicates the organization profile is system generated and can’t be dropped. One of `TRUE` or `FALSE`.
`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.
`owner`	The owner role of the organization profile.

访问控制要求

A role used to execute this operation must have the following privileges at a minimum:

Privilege	Object	Notes
OWNERSHIP or MODIFY or a privileged role, such as ACCOUNTADMIN or SECURITYADMIN	Organization profile

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

示例

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

SHOW ORGANIZATION PROFILES;

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