The database system administrator account is created when the solidDB® database is created; the creator of the database has the SYS_ADMIN_ROLE user role. The system catalog name is also created when the database is created and it cannot be changed later.
By default, the solidDB® server offers a traditional authentication mechanism in which a user has to provide a valid user ID and password combination to connect to a database. Alternatively, you can configure solidDB® to use an operating-system-based external authentication mechanism.
Notes
▪You must remember your username and password to be able to connect to solidDB®. There are no default user names. The administrator username you enter when creating the database is the only username available for connecting to the new database for the first time. If you cannot connect to solidDB® because you have forgotten your system administrator user name or password, contact solidDB® Support.
▪Lowercase characters in user names, passwords, and system catalog names are converted to uppercase.
▪If you try to log in four times with an incorrect username or password, the system blocks your IP address for a maximum of 60 seconds. This feature cannot be configured or switched off.
Username
▪Minimum length: 2 characters.
▪Maximum length: 80 characters
▪The username must begin with a letter or an underscore. Use lowercase letters from a to z, uppercase letters from A to Z, the underscore character _, and numbers from 0 to 9.
The database system administrator’s username cannot be changed with the ALTER USER command. See Changing DBA username and password in the solidDB® SQL Guide.
Password
▪Minimum length: 3 characters.
▪Maximum length: 80 characters
▪The password can begin with any letter, underscore, or number. Use lowercase letters from a to z, uppercase letters from A to Z, the underscore character _, and numbers from 0 to 9.
▪You cannot use the double quotation mark (") in the password. The use of apostrophe ('), semicolon (;), or space is discouraged, because some tools might not accept these characters in the password.
▪If you plan to use solidDB® Remote Control (solcon), do not create passwords with non-ASCII characters, because solcon does not perform UTF-8 translation for any input.
▪The solidDB® passwords do not expire. If you want set up user accounts with expiring passwords, use the operating-system-based mechanism for authentication.
System catalog
▪Minimum length: 1 character.
▪Maximum length: 39 characters.
▪The system catalog name must not contain spaces.
The solidDB® syntax for database object hierarchy is the following:
catalog_name.schema_name.database_object
The default schema name is the username.
If you do not specify the catalog and schema name, the server uses the system catalog and the username of the object creator to determine which object to use.
For details on solidDB® catalogs and schemas, see “Managing database objects” in solidDB® SQL Guide.