Advantage Database Server

sp_GetSecurityInfo

Advantage SQL Engine

sp_GetSecurityInfo

Advantage SQL Engine

Previous topic Next topic  

sp_GetSecurityInfo

Advantage SQL Engine

Previous topic Next topic  

Retrieves security-related information.

Syntax

sp_GetSecurityInfo()

Parameters

None.

Output

The sp_GetSecurityInfo procedure returns a result set containing a single row with the following information:

Field Name

Field Type

Field Size

Description

FIPSMode

Logical

1

Returns TRUE if Advantage Database Server (and, by extension, the client) is in FIPS mode.

EncryptionType

Character

10

Returns the current encryption type for the connection. Values are AES128, AES256, or RC4.

DictionaryEncrypted

Logical

1

Returns TRUE if the connection is a data dictionary connection and the dictionary is encrypted.

CommType

Character

10

Returns the communication type. For local server connections, the value will be LOCAL. Otherwise it is one of: SMC (shared memory communications), TLS (Transport Layer Security communications), TCP_IP (TCP/IP communications), UDP_IP (UDP communications on IP).

TLSCipher

Character

20

If the communications is over TLS, this returns the cipher. The value will be one of: AES128-SHA, AES256-SHA, or RC4-MD5.

TLSVersion

Character

20

If the communications is over TLS, this returns the version information.

See Also

sp_EncryptTable

sp_SetDDEncryptionType

Encryption Overview

Communications Encryption

FIPS