Sec_Network_Auth – PB Docs 126

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.

note.png 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

Parameter

Description

value

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

  • 0

    (Default) Does not use network-based
    login authentication when connecting to the server. You can also
    specify 'No' or 'False' to
    set this value.

  • 1

    Uses network-based login authentication when connecting to the
    server. 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. You can also specify 'Yes' or 'True' to
    set this value.

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:

  • 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 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

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:

See Also


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x