The following table summarizes default values associated with the CREATE USER statement. If you do not define these elements in the CREATE USER statement, the system supplies the default values described in the table.
| Syntax Element | Default Value |
|---|---|
| FROM database | The default database of the creating user. |
| TEMPORARY | If a profile is:
|
| SPOOL | If the profile is:
|
| DEFAULT DATABASE | The user name. The user can submit a SET SESSION DATABASE statement to change the default for the current session, as long as the appropriate privileges on that database are granted to the user. |
| ACCOUNT | If a profile is:
If a user definition specifies an account but not a profile, the default account is the account string in the user definition.
If you assign a profile to a user, and the profile specifies an account string, the profile account is in effect for AMPUsage and DBQL for that user. However, the system uses the value found in the DBC.DatabaseV view for space accounting. |
| DEFAULT ROLE | Null. The database does not use a role for privilege validation unless the user submits a SET ROLE statement for roles that you explicitly grant to the user, including nested roles. |
| STARTUP | Null (no startup string). |
| PROFILE | Null. No profile exists for the user. |