RMS Configuration Database Certification Tables
Applies To: Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 with SP1, Windows Server 2003 with SP2
This topic describes the certification tables that are in the RMS configuration database. The tables contain information about the rights account certificates that are issued for users of this installation.
UD_Machines
The following table lists information about the hardware IDs for all computers.
| Name | Data Type | NULLs | Description |
|---|---|---|---|
i_MachineId |
int |
IDENTITY (1,1) Not NULL |
Internal index |
b_PubKeyHash |
binary(20) |
Not NULL |
Hash of the hardware ID |
dt_CreateDate |
datetime |
Not NULL |
Date and time the entry was added to the table |
UD_PassportAuthIdentities
The following table lists information about Windows Live ID for users.
| Name | Data Type | NULLs | Description |
|---|---|---|---|
i_UserId |
int |
Not NULL |
Internal index |
i64_Puid |
bigint |
NULL |
Windows Live user ID |
UD_UserMachine
The following table links certified users to their corresponding computer information.
| Name | Data Type | NULLs | Description |
|---|---|---|---|
i_MachineId |
int |
Not NULL |
Internal index |
i_UserId |
int |
Not NULL |
Internal index |
dt_CreateDate |
datetime |
Not NULL |
Date and time that the entry was added to the table |
UD_Users
The following table lists information about user data.
| Name | Data Type | NULLs | Description |
|---|---|---|---|
i_UserId |
Int (PK) |
IDENTITY (1,1) Not NULL |
Internal index |
b_KeyData |
varbinary(2000) |
Not NULL |
Encrypted user public/private key |
i_KeyDataLength |
int |
Not NULL |
Length of the unencrypted public/private key |
b_PublicKey |
PublicKey |
Not NULL |
User public key |
i_EncryptionDbId |
int |
Not NULL |
Index to the licensor certificate used to encrypt the public/private key pair |
s_Certificate |
ntext |
Not NULL |
Not used |
dt_Expiration |
datetime |
Not NULL |
Expiration date of the user key |
dt_TemporaryExpiration |
datetime |
Not NULL |
Expiration date and time for temporary use of the key |
f_Modified |
bit |
Not NULL |
Not used |
i_Quota |
int |
Not NULL |
Current level of quota for the user |
i_WaitDays |
int |
Not NULL |
Number of days before additional quota requests can succeed |
dt_LastConsumption |
datetime |
Not NULL |
Date and time of last additional user certification |
dt_CreateDate |
datetime |
Not NULL |
Date and time the entry was added to the table |
UD_Windows AuthIdentities
The following table lists the IDs of all Windows authenticated and certified users.
| Name | Data Type | NULLs | Description |
|---|---|---|---|
i_UserId |
int |
Not NULL |
Internal index |
s_Sid |
Sid |
Not NULL |
Security ID (SID) of the user |