Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Statements : SHOW ENCRYPT ON
 

SHOW ENCRYPT ON

The SHOW ENCRYPT statement provides encryption policy information on the primary database. It can be used only by security administrators or DBAs.

Syntax

SHOW ENCRYPT ON { ALL |[ TABLE | INDEX | LOB ]  
              | TABLE table_name[ WITH INDEX| WITH LOB]       
         | TABLE table_name ON INDEX index_name} ;
When run, the statement returns a result set with eight columns:
*Database object type (AREA, TABLE, INDEX, LOB)
*Database object name
*Object's table name (blank for area)
*Database object name (blank for area)
*Database object identification
*Object policy state (CURRENT or PREVIOUS)
*Object policy cipher name
*Object policy version number

Notes

*Only active policies are returned by the statement.
*The only option which shows Type I area encryption information is the SQL statement SHOW ENCRYPTION ON ALL. Other options on SHOW ENCRYPT show encryption information only for Type II area database objects.
* Authorization
* SQL Compliance
* Related statements