Creating a database name and password

Database names must conform to the following rules:.

Database names

Database names must conform to the following rules:

  • Be between 1-30 characters

  • Begin with a letter

  • Follow with any combination of letters (upper and lowercase), numbers, and/or underscores.

Database names are case sensitive; however, Vertica strongly recommends that you do not create databases with names that differ only in case. For example, do not create a database called mydatabase and another called MyDataBase.

Database passwords

Database passwords can contain letters, digits, and special characters listed in the next table. Passwords cannot include non-ASCII Unicode characters.

The allowed password length is between 0-100 characters. The database superuser can change a Vertica user's maximum password length using ALTER PROFILE.

You use Profiles to specify and control password definitions. For instance, a profile can define the maximum length, reuse time, and the minimum number or required digits for a password, as well as other details.

The following table lists special (ASCII) characters that Vertica permits in database passwords. Special characters can appear anywhere in a password string. For example, mypas$word or $mypassword are both valid.

# ? = _ ' ) @ \
! , ~ : % ; 

|
`^`

|-----
|
`+`

|
`.`

|
`-`

|
`space`

|
`&`

|
`<`

|
`[`

|
`|`

|-----
|
`*`

|
`/`

|
`$` 

|
`"`

|
`(`

|
`>`

|
`]`

|
`{`

|-----
| 
| 
| 
| 
| 
| 
| 
|
`}`

See also