UserIDM

Part-key that uniquely identifies a CA Data Protection user.

Yes

INTEGER

4

None

UserID

Part-key that uniquely identifies a CA Data Protection user.

Yes

INTEGER

4

UserName

The name of the CA Data Protection user. The naming convention (if any) depends on the user creation policy settings.

VARCHAR

64

There may be only one active (non-deleted) user with this user name at any one time.

PolicyIDM

Part-key identifying the policy document for this user.

INTEGER

4

Foreign key: WgnPolicy

PolicyID

Part-key identifying the policy document for this user.

INTEGER

4

Foreign key: WgnPolicy

UserCreateTime

The time that the CA Data Protection user was created.

TIMESTAMP

8

UserRole

The CA Data Protection role assigned to the user. This is used to determine the user's initial privileges.

INTEGER

4

Follow the hyperlink for details.

DeletedFlag

Indicates whether the user account is deleted or not.

BIT

1

UserData

Salt used to hash the password.

VARBINARY

255

PasswordHash

A hashed copy of the users password.

VARBINARY

255

UserPrivileges

A bitmap of CA Data Protection privileges the user is allowed to perform. The initial value is taken from the 'privilege profile' associated with the user's role.

DECIMAL

13

Follow the hyperlink for details.