Documentation

Table of Contents:


    Managing users in SQL Server

    2018-09-19
    Applies to: 7.1 (current), Article available also for: 6.3, 5.2

    To manage user accounts in a repository you need a Dataedo Administration Console. To run the console, choose Dataedo 5 Administration Console from the start menu or run the file named DataedoAdministrationConsole.exe from program installation folder.

    Administration Console access

    To be able to log into the console you need to have one of the following:

    • admins role in the repository database,
    • db_owner role in the repository database (this role is assigned by default to user that created repository),
    • sysadmin role on the server.

    Logging into Administration Console

    When you run the console, login window will open. Type in repository host name, database name and your server admin username and password and click Connect button.

    Main view

    Once you log in you will see a list of users.

    The table shows all users defined on the server. Columns present:

    • Login - user login
    • Is Dataedo user - indicator of whether user is also a Dataedo user
    • License type - the type of a license for a Dataedo user - it includes a name of a license, unique ID, and a number of licenses the key includes.
    • Valid thru - for time-constrained license keys (trial keys or 1 year licenses) it displays a date key is valid thru. If the license key is expired date will be red.
    • Licensed for - the name of entity license was issued for (provided as License Holder at purchase).
    • Host #1 - host name user logged from (host 1 and 2 are users alternately. User can login from maximum 2 hosts during a day.
    • Host #1 last login - Time of the last login from host 1
    • Host #2 - see host #1
    • Host #2 last login - see host #1

    Creating a free Dataedo user

    Creating user for existing server user

    To create a user account for the user that already exists on the server (you can see a login on a list), double click user row - a window should appear:

    Check Is Dataedo user field.

    By default, this user will have a free license key. If you want to enter any license key (Pro or Trial) change License key field to 'Key' and paste key in the field below.

    Click Save and user gets created.

    Creating user for non-existing server user

    To create a new user account, click Add user button:

    A new User details window will open. Provide login and choose authentication mode. If you use SQL Server mode then you need to provide a password for a user. Type it into both fields below.

    Note: You will not be able to change authentication mode after user gets created.

    By default, this user will have a free license key. If you want to enter a license key (Pro or Trial) change License key field to 'Key' and paste the key in the field below.

    Click Save and user gets created.

    Assigning and changing license key

    To assign or change a license key for a specific user double click user row - edit form will show. Paste new key into the key field and save with Save button.

    License key usage limits

    Every license key has a limit of users it can be used for. When you save key, console checks amount.

    Removing license key

    To remove a license key from a user (you might want to use it for another user), double click user row and choose 'Free' in License type field and save with Save button.

    Moving license key

    To move license key from one user to another use instructions on removing and assigning keys above.

    Checking license key

    You can check what license type user has in the License type column. To check when the license key expires look at Valid thru column for a date. If the license key is already expired date will be red.

    Changing password

    To change the password of a Dataedo user double click user and type in the new password in both password fields and save with Save button.

    Note: this option is available only for SQL Server authentication mode.

    Removing user

    To remove Dataedo user from the repository double click existing user and uncheck Is Dataedo user fields and save with Save button.

    Note: Only Dataedo user will be removed - the user will still be defined on the server. To remove SQL Server login use SSMS or contact your database administrator.

    Granting access to Administration Console

    To grant the user an access to the Administration Console you need to assign it admins a role in the repository database.

    You can do it with SQL Server Management Console:

    1. Connect to server
    2. Expand repository database (by default it is "dataedo" database)
    3. Go to Security > Users
    4. Select user, right click and choose Properties option
    5. Check admins role on Membership tab
    6. Confirm with OK button

    To grant the user a permission to create new users (logins on a server) user requires alter any login permission on a server.

    You can do it with SQL Server Management Console:

    1. Connect to server
    2. Go to Security > Logins
    3. Select user, right click and choose Properties option
    4. Go to Securables tab
    5. Select Grant option at Alter any login permission
    6. Confirm with OK button

    Found issue with this article? Comment below
    Comments (0)