|
sp_GetSecurityInfo Advantage SQL Engine |
|
|
|
|
sp_GetSecurityInfo Advantage SQL Engine |
|
|
sp_GetSecurityInfo
Advantage SQL Engine
|
sp_GetSecurityInfo Advantage SQL Engine |
|
|
|
|
sp_GetSecurityInfo Advantage SQL Engine |
|
|
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