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 at a later date.
By default, the solidDB server offers a traditional authentication mechanism in which a user must provide a valid user name and password combination to connect to a database. Alternatively, you can configure solidDB to use an operating-system-based external authentication mechanism, see Operating-system-based external authentication.
Notes
▪ You must remember your user name and password in order to connect to solidDB. There are no default user names. The administrator user name that you provide when you create the database is the only user name available that you can use to connect 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 your solidDB support representative.
▪ Lower case characters in user names, passwords, and system catalog names are converted to upper case.
▪ If you try to log in four times with an incorrect user name or password, the system blocks your IP address for a maximum of 60 seconds. This feature cannot be configured or switched off.
▪ The user name must conform to the following standards:
– Minimum length: 2 characters.
– Maximum length: 80 characters
– The user name must begin with a letter or an underscore.
– The user name can contain lower case letters from a to z, upper case letters from A to Z, the underscore character _, and numbers from 0 to 9.
▪ The password must conform to the following standards:
– Minimum length: 3 characters.
– Maximum length: 80 characters
– The password can begin with any letter, underscore, or number.
– The password can contain lower case letters from a to z, upper case 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.
– You can also enter the password from a file. For more information, see Entering password from a file.
– The solidDB passwords do not expire. If you want set up user accounts with expiring passwords, use the operating-system-based mechanism for authentication.
▪ The system catalog name must conform to the following standards:
– Minimum length: 1 character.
– Maximum length: 39 characters.
– The system catalog name must not contain spaces.
The solidDB database object hierarchy has the following syntax:
catalog_name.schema_name.database_object
The default schema name is the user name.
If you do not specify the catalog and schema name, the server uses the system catalog and the user name of the object creator to determine which object to use.
For details on solidDB catalogs and schemas, see Managing database objects.