Edit User

Edits a user.

Permissions

Command Kind	Needed User Kind
System	Admin, Sys

Parameters

Name	Type	Description	Required	Default	Values
User	string	Name of the user ([User]).	yes
Active	boolean	If 'True' the user is active. Otherwise the user is not able to logon. The default value is 'True'.	no	true
Admin	boolean	If 'True' the user has admin permissions. An admin user has also automatic 'Designer' permissions. The default value is 'False'.	no	false
Designer	boolean	If 'True' the user has designer permissions, i.e. is able to design reports, but has no special database permissions. The default value is 'False'.	no	false
Domain	string	If the domain is not empty the password at logon is checked with the domain. In that case a password in the database is not needed. The server must have access to the domain and the username must be the same as the domain username.	no
Import	boolean	If 'True' the user has the permission to import data ('Import Dimension', 'Import Table'...), independent of database permissions. The default value is 'False'.	no	false
IndividualLog	boolean	If 'True' an individual log file is created for the user. The default value is 'False'. The file name contains the database name, username and the date: Data_<Database>@<User>_YYYY_MM_DD.log.	no	false
Role	string	Name of the role. The permissions of the user and of the role are merged and the highest permission is used.	no
Worksheet	string	Name/path of the start worksheet after logon.	no

Result

Name	Type	Description
User	string	Name of the user.
Active	boolean	If 'True' the user is active and can connect. It can be set with the command 'Edit User'.
Admin	boolean	If 'True' the user has admin permissions.
Designer	boolean	If 'True' the user has designer permissions.
Import	boolean	If 'True' the user has import permissions.
Fixed	boolean	If 'True' the user cannot be changed ('Sys' or 'SysTech').
Domain	string	Domain of the user.
Role	string	Role of the user.
IndividualLog	boolean	If 'True' the user has an individual log file. The file name contains the database name, username and the date: Data_<Database>@<User>_YYYY_MM_DD.log.
Worksheet	string	Start worksheet of the user.

Code

EDIT USER
USER=[string, Needed]
ACTIVE=[boolean, default=true]
ADMIN=[boolean, default=false]
DESIGNER=[boolean, default=false]
DOMAIN=[string]
IMPORT=[boolean, default=false]
INDIVIDUALLOG=[boolean, default=false]
ROLE=[string]
WORKSHEET=[string]