SHOW ORGANIZATION PROFILES¶

Lists the organization profiles for which you have access privileges.

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

Syntax¶

SHOW ORGANIZATION PROFILES

Copy

Output¶

The output of the command includes the following columns, which describe the properties and metadata of the object:

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.

Access control requirements¶

A role used to execute this SQL command must have either of the following privileges at a minimum:

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

To create 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.

Examples¶

The following example lists the organization profiles that you have privileges to access:

SHOW ORGANIZATION PROFILES;

Copy

+-------------------------+-----------------+---------------------+---------------------+---------------------+---------------------------+----------------------------------+---------------------+---------------------+---------------------+
|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         |
+-------------------------+-----------------+---------------------+---------------------+---------------------+---------------------------+----------------------------------+---------------------+---------------------+---------------------+