Contains personal information about a user.

Table Specific Information

Select

All columns support server-side processing for the operators =, >= , <=, !=, LIKE, AND, and OR. Other filters are executed client side within the driver. For example, the following query is processed by LDAP:

SELECT * FROM Person WHERE  ObjectClass = 'top' AND  CN  LIKE '%NewUser%' LIMIT 5 

You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refer to any other operators will cause an error.

Insert

To add a Person, all fields can be specified except Id, DN, and BaseDN. Required fields that should be provided are RDN and ObjectClass. For example:

INSERT INTO Person (RDN, ObjectClass) VALUES ('CN=Domain Admins', 'Person')

Update

All columns except Id, DN, and BaseDN can be updated by providing the Id in the WHERE clause. For example:

UPDATE Person SET Description = 'desc' WHERE Id = '1|CN=NewUser,CN=Users,DC=MyDC'

Delete

Person rows can be deleted by providing the Id of the Person in a DELETE statement. For example:

DELETE FROM Person WHERE Id = '1|CN=NewUser,CN=Users,DC=MyDC'

Columns

Name	Type	ReadOnly	References	DataFormat	Description
Id [KEY]	String	True			Combined index and DN. Multiple indices are only possible when a column is set to SplitDataByRow.
DN	String	True			The full distinguished name.
RDN	String	False			The relative distinguished name.
BaseDN	String	True			The base distinguished name.
ObjectClass_1	String	False		SplitDataByCol	The list of classes from which this class is derived.
ObjectClass_2	String	False		SplitDataByCol	The list of classes from which this class is derived.
ObjectClass_3	String	False		SplitDataByCol	The list of classes from which this class is derived.
ObjectClass_4	String	False		SplitDataByCol	The list of classes from which this class is derived.
SN	String	False		DelimitedData	This attribute contains the family or last name for a user.
CN	String	False		DelimitedData	The name that represents an object. Used to perform searches.
UserPassword	String	False		DelimitedData	The user's password in UTF-8 format. This is a write-only attribute.
TelephoneNumber	String	False		DelimitedData	The primary telephone number.
SeeAlso	String	False		SplitDataByRow	List of distinguished names that are related to an object.
Description	String	False		DelimitedData	Contains the description to display for an object. This value is restricted as single-valued for backward compatibility in some cases but is allowed to be multi-valued in others. See Remarks.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
Filter	String	Defines the LDAP filter explicitly, overriding any other values set in the WHERE clause.