Home
Delete users from the Profiles database
You can use IBM Tivoli Directory Integrator assembly-line commands to delete users from the Profiles database.
To run the Tivoli Directory Integrator assembly-line command that allows you to delete specific users from the Profiles database, first ensure that the dbrepos_fields_prefixed property is set to true. Setting this property to true ensures that the SQL statements have the prefix of PROF_, for example, PROF_UID rather than just UID.
You can use the delete_employee_records assembly-line command to delete specific users from the Profiles database.To delete specific users...
- Create a text file named delete_employees.in that contains the distinguished names and user IDs for the users that you want to delete from the database. Use the following format to represent a user:
$dn:<user_dn> uid:<user_uid> .where:
- <user_dn> corresponds to the PROF_SOURCE_UID in the Profiles database.
- <user_uid> corresponds to the PROF_UID in the Profiles database.
When deleting multiple users, there must be a period separator between each entry. The "." must be added after the row containing the user's UID. If the separator is omitted, an error is thrown when you use the delete command to delete the users from the database.
- Place the file in the Tivoli Directory Integrator location specified for your deployment. For more information, see Configuring Tivoli Directory Integrator.
- Use the following command to delete the users from the database:
delete_employee_recordsThe following table shows the property that is used by this command, and its default value. This property can be found in the profiles_tdi.properties file.
The delete_employees_simple_file property
Property Description delete_employees_simple_file The list of people that will be deleted from the database. The default value is delete_employees.in.
Example
Here is an example of an entry from the delete_employees.in file:$dn:cn=Amy Jones3,cn=Users,l=WestfordFVT,st=Massachusetts,c=US,ou=Lotus,o=Software Group,dc=ibm,dc=com uid:Amy Jones3 .When loading multiple users, there must be a period separator between each entry.For example:
$dn:cn=Amy Jones3,cn=Users,l=WestfordFVT,st=Massachusetts,c=US,ou=Lotus,o=Software Group,dc=ibm,dc=com uid:Amy Jones3 . $dn:cn=Amy Jones8,cn=Users,l=WestfordFVT,st=Massachusetts,c=US,ou=Lotus,o=Software Group,dc=ibm,dc=com uid:Amy Jones8 .
Related tasks
Configure Tivoli Directory Integrator