Skip to content

Show Connection

Shows the active connection.

Permissions

Command KindNeeded User Kind
ReadAll

Parameters

None

Result

NameTypeDescription
UserstringName of the connected user.
UidstringUnique ID, to identify the connection which is used for subsequent commands.
DatabasestringName of the connected database.
ClientUserAgentHashstringHash of the client user agent.
ClientIpHashstringHash of the client IP address.
ServerHoststringIp address of the server.
ServerPortintegerPort of the server.
Sysboolean'True' if user is 'Sys'.
SysTechboolean'True' if user is 'SysTech'.
AdminbooleanIf 'True' the connected user has admin permissions.
DesignerbooleanIf 'True' the connected user has designer permissions.
ImportbooleanIf 'True' the connected user has the permission to import data ('Import Dimension', 'Import Table'...), independent of database permissions.
FixedbooleanIf 'True' the connected user cannot be changed ('Sys' or 'SysTech').

Code

text
SHOW CONNECTION