Detecting Advanced Security through database tables
456161Apr 22 2009 — edited Apr 25 2009Hi,
I would like to be able to check if Advanced Security is being used by running scripts. I have the scripts for 10g and above as shown below.
Does anyone know the equivalent scripts in 9i and 8i which I can use to perform the same function? specifically, the network_service_banner, equivalent DBA_ENCRYPTED_COLUMNS table and the equivalent ENCRYPTED column.
Thank you!!
Ellice
For network encryption and strong authentication
select count(*) from v$session_connect_info where network_service_banner in 'authentication service, encryption service, crypto_checksumming';
if > 0, network encryption and/or authentication is in use.
To see if TDE column encryption is used
'select count(*) from dba_encrypted_columns;'
returns more than zero rows.
To see if TDE tablespace encryption is used
'select count(*) from dba_tablespaces where encrypted ='YES';'