User Administration

The user types of Interface Scan are based on the users and roles of the database. A database administrator can therefore administrate users with their usual tools. We recommend using the generation tool for creating the used roles.

To facilitate the creation of necessary roles, you can generate scripts for creating users within Interface Scan. You can access the generator via Administration > Tools > Generate database role.

HINWEIS The generated scripts must not be listed as a general query. Execute them using the Microsoft SQL Management Studio.
BEISPIEL

The window SQL script generation: Role including a user displays the following fields and elements:

ElementDescription
RoleSelect the role you want to create (User, Implementation, Admin)
Database

Name of the database

HINWEIS If possible, do not change the name.
Schema

Name of the schema

HINWEIS Only the S1 schema is supported.
Windows User

Creates a user (commented out) based on an Microsoft Windows user (hides the password field)

If this option is disabled, a user is created based on the SQL login information. The password used must correspond to the Microsoft Windows server guidelines. Otherwise, you cannot create the user.

UserName of the user for creation using an SQL script (commented out)
PasswordPassword of the user for creation using an SQL script (only for SQL login; commented out)
GenerateGenerates the SQL script using the specified data
CancelCloses the window
Generated database role Script

Contains (after generation) the SQL script for creating roles, based on the specified data

The creation of the user is displayed commented out at the end of the script.

Role Authorizations Overview

FunctionUserImplementerAdministrator
Perform an analysis in the Central Query tabXXX

Perform an analysis in the General Query tab.

HINWEIS * The Utilities node is only visible to the administrator.
XXX*

Create analysis queries

HINWEIS * The user can only customize existing queries and save them as a new query; the editor window is read-only.
(X)*XX
Change personalized user settingsXXX
Change global user settings  X
Adapt the Interface Scan configuration in the Configuration tab  XX
Execute administrator functions in the Administrator tab  X