Sec_Network_Auth

Description

When you access a Sybase 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.

NoteUsing 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.

Applies to

Syntax

Sec_Network_Auth=value

Parameter

Description

value

Specifies whether your connection uses network-based login authentication when connecting to a secure SQL Server. Values are:

Default

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:

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_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 “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 Sybase CT-Lib connection property named CS_SEC_NETWORKAUTH.

Examples

Example 1

To specify that your connection uses network-based login authentication when connecting to the server:

See also