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.
The window SQL script generation: Role including a user displays the following fields and elements:
Element | Description |
---|---|
Role | Select 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. |
User | Name of the user for creation using an SQL script (commented out) |
Password | Password of the user for creation using an SQL script (only for SQL login; commented out) |
Generate | Generates the SQL script using the specified data |
Cancel | Closes 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
Function | User | Implementer | Administrator |
---|---|---|---|
Perform an analysis in the Central Query tab | X | X | X |
Perform an analysis in the General Query tab. HINWEIS * The Utilities node is only visible to the administrator. | X | X | X* |
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)* | X | X |
Change personalized user settings | X | X | X |
Change global user settings | X | ||
Adapt the Interface Scan configuration in the Configuration tab | X | X | |
Execute administrator functions in the Administrator tab | X |