Sec_Server_Principal
database parameter
Description
When you access an SAP Adaptive Server Enterprise database in
PowerBuilder through Open Client, Sec_Server_Principal is one of several
parameters that support login authentication for network-based security
services. (For other login authentication parameters, see the See Also
section.)
Sec_Server_Principal specifies the principal name of the server
that you want to access. The server principal name is the name by which
your security mechanism identifies each server.
If the server name (specified in the database profile or
Application) is different from the server principal name for the server
you want to access, you must set Sec_Server_Principal to the correct
server principal name in order to connect.
You must specify a value for Sec_Server_Principal 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 has been tested with Open Client
security services, see the Open Client documentation.
Applies to
ASE, SYC SAP Adaptive Server Enterprise
Syntax
|
1 |
Sec_Server_Principal='server_principal_name' |
|
Parameter |
Description |
|---|---|
|
server_principal_name |
Specifies the principal name of the server you want |
Default value
None
If you do not specify a value, the security mechanism uses the
server’s directory entry name, which is the same as the server name
specified in the database profile or Application.
Usage
When to use
When you use Open Client security services with PowerBuilder, the
server’s directory entry name (which you specify as the server name in
the database profile or Application) might differ from the server
principal name. In this case, you must set Sec_Server_Principal to the
correct server principal name so that the security mechanism can
identify the server you want to access.
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_Server_Principal 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_Server_Principal sets the corresponding
SAP Sybase CT-Lib connection property named
CS_SEC_SERVERPRINCIPAL.
Examples
To specify SYS12NT as the principal name of the server you want to
access:
-
Database profile
Type SYS12NT in the Server Principal Name box on the Security
page in the Database Profile Setup dialog box. -
Application
Type the following in code:
1SQLCA.DBParm="Sec_Server_Principal='SYS12NT';Release=12"
See also