|
User Management |
  
|
|
User Management |
|
Description
With the SQL Server data source, you can create users and give them security access. By default, all SQL Server SYSDBA users are administrators. You must be administrator of the database (not Remote Desktop Manager) to create users and assign rights. The user/group administration is available from the menu in File > Administration, and only when a SQL Server data source is selected.
Administration menus
Security Groups are used to classify sessions and restrict access to certain users. There is no direct relationship between Active Directory and Security Groups. By default, every session is created without security groups, and is visible to all connected users.
Steps:
| 1. | Create the security groups |
| 2. | Assign the security group to the session |
| 3. | Create the required users |
| 4. | Link the security group to a user |
Notes: All sessions without security groups are considered public.
Creating Security Groups
Security groups are created from the menu in File > Administration.
Security group dialog
Assigning a Security Group to a Session
Security groups can be assigned to sessions using the session's property window. Each session can only have one security group assigned.
Session configuration - security group
Creating Required Users
If you wish, you can create a user linked to a domain. This dialog will create a login in SQL Server and a user in the current database. The login name is used to connect to the SQL Server, and the username is used to connect to the database. Typically, these have the same name.
If the connection already exists in the SQL Server database, the user will be created by using the existing password instead of the new one. You can assign different security options to a user, such as the offline mode, a read-only mode, and more. However, there is currently no way to inherit security rights from a group. They must be assigned individually for each user.
User dialog
Linking a Security Group to a User
In the user editor, you can check or uncheck groups. A user with administrator rights has access to all of the configured sessions from all groups.
User dialog - groups