When creating a new user, the user may be assigned to one or more account ID. The ACCOUNT option in CREATE USER is used to assign the account. Account is used to analyze the system performance under CPU/IO and space usage, to plan capacity, and for charge back billing. The account string is limited to 128 characters.
When no account ID is specified in the CREATE or MODIFY user statement, it defaults to the database owner's.
Account IDs may begin with $L, $M, $H, or $R. They show different performance groups. General guidelines on performance groups are:
$L: Low$M: Medium$H: High$R: Rush
ASE (Account String Expansion): Substitution variables can be used in the account ID portion of a user's logon string. ASE is a mechanism to provide more detailed utilization reports and user accounting data. Valid ASE variables are:
- &: An ampersand designates an account string expansion. Can be used with the other variables listed here.
- L: Logon timestamp.
- D: Date.
- T: Time.
- H: Hour.
- I: Logon...