grant-db-role-sub-procedure.md

  1. Choose a database. Select a database from the list of MC-discovered (databases that were created on or imported into the MC interface).

  2. Database username. Enter an existing database user name or, if the database is running, click the ellipsis [...] to browse for a list of database users, and select a name from the list.

  3. Database password. Enter the password to the database user account (not this username's password).

  4. Restricted access. Choose a database level (ADMIN, IT, or USER) for this user.

  5. Click OK to close the Add permissions dialog box.

  6. If the Vertica database is configured to require TLS, select Yes in the Use TLS Connection drop-down. MC launches the Certificates wizard to let you configure TLS. See MC certificates wizard.