1
Download Enterprise Server Administrator`s Guide for Windows
Transcript
ACROBAT CONNECT 20 Enterprise Server Administrator’s Guide for Windows Column Data type Description LOGIN NVARCHAR Unique user identifier. NAME NVARCHAR Field name such as telephone number. VALUE NVARCHAR Field value such as 415.555.1212. Sample query and data The following query returns the data in the following table: select * from ext_user_fields where login = '[email protected]'; LOGIN NAME VALUE [email protected] {email} [email protected] [email protected] {first-name} test4 [email protected] {last-name} laxmi [email protected] {x-job-title} sw engr 4 [email protected] {x-direct-phone} NULL [email protected] {x-direct-phone-key} NULL [email protected] SSN 777 Generating data Actions that generate data in this view: adding, creating, or updating new or predefined custom fields for one or more users. EXT_USER_GROUPS The EXT_USER_GROUPS view lists data about groups and associated group members. The EXT_USER_GROUPS view uses the data listed in the following table: Column Data type Description LOGIN NVARCHAR Name of user. NAME NVARCHAR Name of group. Sample query and data The following query returns the data in the following table: select * from ext_user_groups where login = '[email protected]'; LOGIN NAME [email protected] {admins} [email protected] {authors} [email protected] {everyone} [email protected] Laxmi Nagarajan Query notes Nesting of multiple groups is supported in version 5.1 and later. For example, if group A contains group B, and you are in group B, you are listed as a member of A.
