sp_loginconfig

(Windows only) Displays the value of one or all integrated security parameters.

Syntax

sp_loginconfig ["parameter_name"]

Parameters

Examples

Usage

There are additional considerations when using sp_loginconfig:
  • The values of integrated security parameters are stored in the Windows Registry. See the chapter on login security in Configuration Guide for Windows for instructions on changing the parameters.

  • sp_loginconfig displays the config_item values that were in effect when you started the SAP ASE server. If you changed the Registry values after starting the SAP ASE server, those values are not reflected in the sp_loginconfig output.

See also Configuration Guide for Windows.

Permissions

The permission checks for sp_loginconfig differ based on your granular permissions settings.

SettingDescription
Enabled

With granular permissions enabled, you must be a user with manage any login privilege.

Disabled

With granular permissions disabled, you must be a user with sa_role.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

InformationValues
Event

38

Audit option

exec_procedure

Command or access audited

Execution of a procedure

Information in extrainfo
  • Roles – Current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – All input parameters

  • Proxy information – Original login name, if set proxy in effect

Related reference
sp_revokelogin