Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

extern_login_credentials option

Controls whether the external login credentials of the session user or the executing (effective) user are used when making remote connections. This option is provided for backwards compatibility. For security reasons, do not specify this option.

Allowed values

Login_user, Effective_user

Default

Effective_user

Scope
  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY SECURITY OPTION No No
Allowed to set temporarily? Yes, with SET ANY SECURITY OPTION No No
Remarks

This option specifies whether remote data access connections are performed using the external login credentials of the session user or the current executing user. The session user is the user who is connected; whereas the current executing user can be different based on stored procedure calls.

  • Login_user

    When Login_user is specified, the database server always uses the session user's external login credentials when making remote data access connections, regardless of what the current executing user is.

  • Effective_user

    When Effective_user is specified, the database server respects the setting of the current executing user. Remote connections are made based on the external login credentials of the current executing user. Specifying Effective_user can result in multiple (one per current executing user) remote connections for the same local connection.