Sec_Seq_Detection database parameter
Description
When you access an SAP Adaptive Server Enterprise database
in PowerBuilder through Open Client, Sec_Seq_Detection
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_Seq_Detection controls whether your
connection’s security mechanism can detect and reject transmitted
packets that arrive at the server in a different order than was
originally sent from the client. When Sec_Seq_Detection
is set to 1, the security mechanism detects and rejects packets
that arrive at the server out of sequence.
When Sec_Seq_Detection is set to 0 (the
default), the security mechanism cannot detect packets that arrive
at the server out of sequence.
You must specify a value for Sec_Seq_Detection 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 Sybase has tested
with Open Client security services, see the Open Client documentation.
Controls
-
ASE, SYC SAP Adaptive
Server Enterprise
Syntax
|
1 |
Sec_Seq_Detection=<span>value</span> |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether your connection’s
|
Default
Sec_Seq_Detection=0
Usage
When to use
When transmitting data over a network, commands sent to a server
might arrive out of sequence. For example, if packets are sent from
the client to the server in the order P1, P2, P3 and the server
receives the packets in the order P1, P3, P2, this is considered
an out-of-sequence error.
Setting Sec_Seq_Detection to 1 ensures that
your security mechanism can detect and subsequently reject packets
that arrive at the server out of sequence.
Set Release parameter
For this parameter to take effect, you must also
set the Release parameter to 11or higher to specify that your application
should use the appropriate version of Sybase Open Client Client–Library
(CT-Lib) behavior. See the description of the Release parameter
for more information.
Requirements for use
To use Sec_Seq_Detection 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 “Requirements for using Open Client security services” in Connecting
to Your Database.
Corresponding CT-Lib connection property
Specifying a value for Sec_Seq_Detection
sets the corresponding Sybase CT-Lib connection property named CS_SEC_DETECTSEQ.
Examples
To allow your security mechanism to detect and reject
packets that arrive at the server out of sequence:
-
Database profile
Select the Detect Sequence Errors check box on the Security
page in the Database Profile Setup dialog box. -
Application
Type the following in code:
1SQLCA.DbParameter="Sec_Seq_Detection=1;Release=15"