User Accounts and Types

Owned by Hadden Grant
Last updated: Aug 30, 2023
3 min read

What are User Accounts?

A user is a database level security control. System logins must be mapped to a database user to connect to the database. Creating users and mapping them to the Velocity Database here will allow them to log into the Workstation and access Velocity.

When installed, Velocity will either download or access SQL on the Workstation, or connect to the SQL Server, and download the Velocity Database. Once SQL is open, inside ‘Velocity', under 'Security’, you will find the ‘Users’ folder where users can be added, edited and deleted as needed.

Types of Users

  1. SQL user with login: Has access to the SQL instance and SQL database. Can be given access to multiple databases.

  2. SQL user without login: Has access to the SQL instance and SQL database. When created, no login identity is associated with it, but logins can be associated with it later on, allowing access to people using the log in.

  3. User mapped to a certificate: Has access to the SQL instance and SQL database. The certificate given to the user has a specific public or private key to the SQL server assigned to it, which is used to access the database.

  4. User mapped to an asymmetric key: Has access to the SQL instance and SQL database. The asymmetric key given to the user has a private and public key used to access the database.

  5. Windows user: Windows user information is used to also access the SQL database only.

 

Map explaining the types of accounts in SQL

When you select an option, the remaining options in the dialog may change. Some options only apply to specific types of database users. Some options can be left blank and will use a default value.

  1. User name
    Enter a name for the new user. If you have chosen Windows user from the User type list, you can also click the ellipsis (...) to open the Select User or Group dialog box.

  2. Login name
    Enter the login for the user. Alternately, click the ellipsis (...) to open the Select Login dialog box. Login name is available if you select either SQL user with login or Windows user from the User type list.

  3. Password and Confirm password
    Enter a password for users who authenticate at the database.

  4. Default language
    Enter the default language of the user.

  5. Default schema
    Enter the schema that will own objects created by this user. Alternately, click the ellipsis (...) to open the Select Schema dialog box. Default schema is available if you select either SQL user with login, SQL user without login, or Windows user from the User type list.

  6. Certificate name
    Enter the certificate to be used for the database user. Alternately, click the ellipsis (...) to open the Select Certificate dialog box. Certificate name is available if you select User mapped to a certificate from the User type list.

  7. Asymmetric key name
    Enter the key to be used for the database user. Alternately, click the ellipsis (...) to open the Select Asymmetric Key dialog box. Asymmetric key name is available if you select User mapped to an asymmetric key from the User type list.