SHOW CATEGORY

Use the SHOW CATEGORY command to display one or more categories.

Synopsis

Syntax for displaying one or more categories:
SHOW CATEGORY [ [NAME] <category-name> | ALL ]

Inputs

The SHOW CATEGORY command has the following inputs:
Table 1. SHOW CATEGORY inputs
Input Description
ALL When ALL is specified, all security categories are displayed. ALL is the default.
<category-name> The name of a security category to display.

Outputs

The SHOW CATEGORY command has the following output:

Display all categories:
SYSTEM.ADMIN(ADMIN)=> SHOW CATEGORY ALL;
NAME | ID 
------+----
 ABC  |  1
 DEF  |  2
 GHI  |  3
 OMNI |  0
(4 rows)
Display one category:
SYSTEM.ADMIN(ADMIN)=> SHOW CATEGORY abc;
NAME | ID 
------+----
 ABC  |  1
(1 row)
Display non-existent category:
SYSTEM.ADMIN(ADMIN)=> SHOW CATEGORY xyz;
NAME | ID 
------+----
(0 rows)
Attempt to display categories by a user without Manage Security permissions:
DEV.SCH(DD)=> SHOW CATEGORY All;
NAME | ID 
------+----
(0 rows)

Description

Privileges required
You must have Manage Security privilege to show security categories.
Common tasks
Use the SHOW CATEGORY command to display one or more categories.

Usage

The following provides sample usage:
SHOW CATEGORY ALL;