(Windows only) Displays the value of one or all integrated security parameters.
sp_loginconfig ["parameter_name"]
login mode
default account
default domain
set host
key _
key $
key @
key #
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 # -
sp_loginconfig "login mode"
name config_item ---------------------- ---------------------- login mode standard
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.
The permission checks for sp_loginconfig differ based on your granular permissions settings.
Setting | Description |
---|---|
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. |
Values in event and extrainfo columns from the sysaudits table are:
Information | Values |
---|---|
Event | 38 |
Audit option | exec_procedure |
Command or access audited | Execution of a procedure |
Information in extrainfo |
|