RMS Configuration Database Certification Tables

Updated: June 1, 2008

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

Community Additions

ADD
Show: