(Windows only) Displays the value of one or all integrated security parameters.
sp_loginconfig ["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 #
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 # -
Displays the value of the login mode security parameter:
sp_loginconfig "login mode"
name config_item ---------------------- ---------------------- login mode standard
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.
The permission checks for sp_loginconfig differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions enabled, you must be a user with manage any login privilege. |
Granular permissions disabled |
With granular permissions disabled, you must be a user with sa_role. |
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 |
|
System procedures sp_revokelogin
