SHOW SECURITY LEVEL

Use the SHOW SECURITY LEVEL command to display one or all security levels.

Synopsis

Syntax for showing a security level:

SHOW SECURITY LEVEL [ [NAME] <level-name> | ALL ]

Inputs

The SHOW SECURITY LEVEL command has the following inputs:

Table 1. SHOW SECURITY LEVEL inputs
Input	Description
ALL	When ALL is specified, all security levels are displayed. ALL is the default.
<level_name>	The name of a security level to display.

Outputs

The SHOW SECURITY LEVEL command has the following outputs:

Display all security levels:

DEV(ADMIN)=> SHOW SECURITY LEVEL ALL;
NAME  | LEVEL 
--------+-------
 PUBLIC |     0
 LOW    |    10
 MED    |    20
 HIGH   |    30
 OMNI   | 32767
(5 rows)

Display one security level:

DEV(ADMIN)=> SHOW SECURITY LEVEL med;
NAME | LEVEL 
------+-------
 MED  |    20
(1 row)

Display non-existent security level:

DEV(ADMIN)=> SHOW SECURITY LEVEL xyzzy;
NAME | LEVEL 
------+-------
(0 rows)

Attempt to display security levels by a user without Manage Security permissions:

DEV.SCH(DD)=> SHOW SECURITY LEVEL ;
NAME | LEVEL 
------+-------
(0 rows)

Description

The SHOW SECURITY LEVEL command has the following characteristics:

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

Usage

The following provides sample usage:

SHOW SECURITY LEVEL ALL;