DBA_ENCRYPTED_COLUMNS view tips

Oracle Tips by Burleson Consulting

DBA_ENCRYPTED_COLUMNS

<< Return to the index

Oracle 11g makes the following comments about the DBA_ENCRYPTED_COLUMNS table: "Encryption information on columns in the database"

Column description of the DBA_ENCRYPTED_COLUMNS view:

OWNER

Description of DBA_ENCRYPTED_COLUMNS.OWNER: "Owner of the table"

TABLE_NAME

Description of DBA_ENCRYPTED_COLUMNS.TABLE_NAME: "Name of the table"

COLUMN_NAME

Description of DBA_ENCRYPTED_COLUMNS.COLUMN_NAME: "Name of the column"

ENCRYPTION_ALG

Description of DBA_ENCRYPTED_COLUMNS.ENCRYPTION_ALG: "Encryption algorithm used for the column"

SALT

Description of DBA_ENCRYPTED_COLUMNS.SALT: "Is this column encrypted with salt? YES or NO"

DBA_ENCRYPTED_COLUMNS View Source

Oracle 11g's data dictionary defines the DBA_ENCRYPTED_COLUMNS view using the following source query:

select u.name, o.name, c.name,
case e.ENCALG when 1 then '3 Key Triple DES 168 bits key'
when 2 then 'AES 128 bits key'
when 3 then 'AES 192 bits key'
when 4 then 'AES 256 bits key'
else 'Internal Err'
end,
decode(bitand(c.property, 536870912), 0, 'YES', 'NO')
from user$ u, obj$ o, col$ c, enc$ e
where e.obj#=o.obj# and o.owner#=u.user# and bitand(flags, 128)=0 and
e.obj#=c.obj# and bitand(c.property, 67108864) = 67108864

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.
You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books