SHOW COHORT

Use the SHOW COHORT command to display one or more cohorts or to display the cohort hierarchy.

Synopsis

Syntax for displaying cohorts:

SHOW COHORT [ [NAME] <cohort-name> | ALL ] [ HIERARCHY ]

Inputs

The SHOW COHORT command has the following inputs:

Table 1. SHOW COHORT inputs
Input	Description
ALL	When ALL is specified, all security cohorts are displayed. ALL is the default.
<cohort_name>	The name of a security cohort to display.
HIERARCHY	When HIERARCHY is specified, the parent-child hierarchy of cohorts is displayed.

Outputs

The SHOW COHORT command has the following outputs:

Display all cohorts:

SYSTEM.ADMIN(ADMIN)=> SHOW COHORT ALL;
NAME   | ID | CLOSURE 
---------+----+---------
 HR         |  2    | HR
 SW         |  1 | SW
    HW       |  3 | HW
 OMNI          |  0 | 
(4 rows)

Display one cohort:

SYSTEM.ADMIN(ADMIN)=> SHOW COHORT HR;
NAME | ID | CLOSURE 
------+----+---------
 HR        |  2 | HR
(1 row)

Display non-existent cohort:

SYSTEM.ADMIN(ADMIN)=> SHOW COHORT notthere;
NAME | ID | CLOSURE 
------+----+---------
(0 rows)

Attempt to display cohorts by a user without Manage Security permissions:

DEV.SCH(DD)=> SHOW COHORT HR;
NAME | ID | CLOSURE 
------+----+---------
(0 rows)

Description

The SHOW COHORT command has the following characteristics:

Privileges required: You must have Manage Security privilege to show security cohorts.
Common tasks: Use the SHOW COHORT command to display the security cohorts.

Usage

The following provides sample usage:

SHOW COHORT HR;