HP Device Manager 4.5 - Database Schema Guide

38
dm_user
This is the user table.
1. Table columns
Column Name
Type Name
Column Size
Nullable
Primary Key
Foreign Key
Description
user_id
nvarchar
50
NO
√
dm_user_filter.user_id
dm_user_sec_filter.user_id
User name
dn
nvarchar
255
YES
Distinguish name
(only when user type
is LDAP will it have
a value)
description
nvarchar
50
NO
Description
information
password
nvarchar
50
NO
Encrypted password
privilege
int
10
YES
Privilege
user_type
int
10
NO
User type:
0: unknown
1: local
2: ldap
security_filter
nvarchar
32
YES
Security filter name
2. Relevant UI