Skip to content

Create Role

Creates a role.

Permissions

Command KindNeeded User Kind
WriteAdmin, Sys

Parameters

NameTypeDescriptionRequiredDefaultValues
RolestringName of the role ([Role]).yes
AdminbooleanIf 'True' the role has admin permissions. An admin role has also automatic 'Designer' permissions. The default value is 'False'.nofalse
DesignerbooleanIf 'True' the role has designer permissions. It is able to design reports, but has no special database permissions. The default value is 'False'.nofalse
ImportbooleanIf 'True' the role has the permission to import data ('Import Dimension', 'Import Table'...), independent of database permissions. The default value is 'False'.nofalse
WorksheetstringName/path of the start worksheet after logon.no

Result

NameTypeDescription
RolestringName of the role.
AdminbooleanIf 'True' the role has admin permissions.
DesignerbooleanIf 'True' the role has designer permissions.
ImportbooleanIf 'True' the role has import permissions.
WorksheetstringStart worksheet of the role.

Code

text
CREATE ROLE
ROLE=[string, Needed]
ADMIN=[boolean, default=false]
DESIGNER=[boolean, default=false]
IMPORT=[boolean, default=false]
WORKSHEET=[string]