Sec_Network_Auth
database parameter
Description
When you access an SAP Adaptive Server Enterprise database in
PowerBuilder through Open Client, Sec_Network_Auth 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_Network_Auth controls whether your connection uses
network-based login authentication. When Sec_Network_Auth is set to 1,
your connection uses network-based authentication when connecting to a
secure SQL Server. Network-based authentication means that the security
mechanism — not the application — confirms that the specified user
name represents the authenticated user running the application.
Since the security mechanism rather than the application
authenticates your user name (login ID), you need not supply a login
password for authentication purposes in the database profile or
Application if Sec_Network_Auth is set to 1.
When Sec_Network_Auth is set to 0 (the default), your connection
does not use network-based login authentication to connect to the
server. You must specify a value for Sec_Network_Auth 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_Network_Auth=value |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether your connection uses
|
Default value
Sec_Network_Auth=0
Usage
When to use
Setting Sec_Network_Auth to 1 to enable network-based login
authentication provides three important benefits for PowerBuilder users,
because you do not have to specify a login password in the database
profile or Application to authenticate the login ID when
Sec_Network_Auth is set to 1:
-
Password not stored in registry file
Since you do not specify a login password, no login password
is stored in the Windows registry. -
Password not transmitted across network
Since you do not specify a login password, no login password
is transmitted across the network to Adaptive Server. -
Same user ID and password for different servers
You can use the same network user ID and password to connect
to many different Adaptive Server database servers. You can change
your password for the network security mechanism and have this
change apply on all servers to which your application
connects.
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_Network_Auth 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_Network_Auth sets the corresponding SAP
Sybase CT-Lib connection property named CS_SEC_NETWORKAUTH.
Examples
To specify that your connection uses network-based login
authentication when connecting to the server:
-
Database profile
Select the Network Based Authentication check box on the
Security page in the Database Profile Setup dialog box. -
Application
Type the following in code:
1SQLCA.DBParm="Sec_Network_Auth=1;Release=15"
See also