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.