Sec_Confidential
database parameter
Description
When you access an SAP Adaptive Server Enterprise database in
PowerBuilder through Open Client, Sec_Confidential is one of several
parameters that support per-packet security for network-based security
services. (For other per-packet security parameters, see the See Also
section.)
Sec_Confidential controls whether transmitted data is encrypted.
When Sec_Confidential is set to 1, all requests sent to the server and
all results returned by the server are encrypted.
When Sec_Confidential is set to 0 (the default), transmitted data
is not encrypted.
You must specify a value for Sec_Confidential before connecting to
the database in PowerBuilder.
Using third-party security mechanisms
For information about the third-party security mechanisms and
operating system platforms that SAP has tested with Open Client
security services, see the Open Client documentation.
Applies to
ASE, SYC SAP Adaptive Server Enterprise
Syntax
|
1 |
Sec_Confidential=value |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether transmitted data is encrypted.
|
Default value
Sec_Confidential=0
Usage
When to use
Encryption can protect your data if you are sending it over a
public network to a nonsecure server. In a networked environment, you
might want to set Sec_Confidential to 1 to ensure that all requests sent
to the server and all results returned by the server are
encrypted.
Set Release parameter
For this parameter to take effect, you must also set the Release
parameter to 11 or higher to specify that your application should use
the appropriate version of SAP Sybase Open Client Client-Library
(CT-Lib) behavior. See the description of the Release parameter for more information.
Requirements for use
To use Sec_Confidential or any other parameter supporting Open
Client security services, you must meet certain requirements for using
security services in your PowerBuilder application. For details, see
the section called “Requirements for using Open Client security services” in Connecting to Your Database.
Corresponding CT-Lib connection
property
Specifying a value for Sec_Confidential sets the corresponding SAP
Sybase CT-Lib connection property named CS_SEC_CONFIDENTIALITY.
Examples
To specify that transmitted data is encrypted:
-
Database profile
Select the Encrypt All Results check box on the Security page
in the Database Profile Setup dialog box. -
Application
Type the following in code:
1SQLCA.DBParm="Sec_Confidential=1"
See also