sp_displaylevel

Syntax

sp_displaylevel [loginame [, level]]

loginame – is the SAP ASE login of the user for whom you want to set or show the display level.
level – sets the display level to one of the following:
- “basic” display level shows just the most basic configuration parameters. This level is appropriate for very general server tuning.
- “ intermediate” display level shows configuration parameters that are somewhat more complex, as well as all the “basic” level parameters. This level is appropriate for moderately complex server tuning.
- “ comprehensive” display level shows all configuration parameters, including the most complex ones. This level is appropriate for highly detailed server tuning.

Example 1 – Shows the current display level for the user who invoked sp_displaylevel:
```
sp_displaylevel
```
```
The current display level for login 'sa' is 'comprehensive'.
```

Example 2 – Shows the current display level for the user “jerry”:

sp_displaylevel jerry

The current display level for login 'jerry' is 'intermediate'.

Example 3 – Sets the display level to “comprehensive” for the user “jerry”:

sp_displaylevel jerry, comprehensive

The display level for login 'jerry' has been changed to 'comprehensive'.

See the System Administration Guide for details about display levels and configuration parameters.

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

Setting	Description
Enabled	With granular permissions enabled, you must be a user with `manage server configuration` privilege. Any user can execute sp_displaylevel to set and show their own configuration parameters.
Disabled	With granular permissions disabled, you must be a user with sso_role. Any user can execute sp_displaylevel to set and show their own configuration parameters.

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`	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