Chapter 1: System Procedures

sp_loginconfig

Description

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

Syntax

sp_loginconfig ["parameter_name"]

Parameters

parameter_name

is the name of the integrated security parameter you want to examine. Values are:

login mode
default account
default domain
set host
key _
key $
key @
key #

Examples

Example 1

Displays the values of all integrated security parameters:

sp_loginconfig

name                config_item
---------------------- ----------------------
login mode          standard
default account     NULL
default domain      NULL
set host            false
key _               domain separator
key $               space
key @               space
key #               -

Example 2

Displays the value of the login mode security parameter:

sp_loginconfig "login mode"

name                config_item
---------------------- ----------------------
login mode          standard

Usage

The values of integrated security parameters are stored in the Windows NT Registry. See the chapter on login security in Configuration Guide for Windows NT for instructions on changing the parameters.
sp_loginconfig displays the config_item values that were in effect when you started Adaptive Server. If you changed the Registry values after starting Adaptive Server, those values are not reflected in the sp_loginconfig output.

Permissions

Only a System Administrator can execute sp_loginconfig.

Auditing

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

Event	Audit option	Command or access audited	Information in extrainfo
38	exec_procedure	Execution of a procedure	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