Delete Person

If a person leaves the company or changes jobs so that they no longer need to use the database, you can delete that person using the Delete Person command.

You cannot delete users using MQL if that user was created for the 3DEXPERIENCE platform using the Members Control Center app.

delete person NAME;
  • NAME is the name of the person to be deleted.

This command searches the list of defined persons. If the name is not found, an error message is displayed. If the name is found, the person is deleted only if there are no references to the person. A reference could be that the person owns an object or connection, or is a grantee on a business object.

To determine the business objects and relationships that reference a person, you can execute these MQL commands:

temp query bus * * * where owner==<person>
temp query bus * * * where grantee==<person>
query connection type * where owner==<person> select id

where <person> is the name of the person you plan to delete.

If the person is referenced by an extensive number of objects or has been heavily involved in the history of many objects (such as a manager signing off), you might want to make the person inactive rather than delete them. By assigning an Inactive type to the person, you have a point of reference when that user name comes up in history records or elsewhere.

If you still want to delete the person, use the results of the above queries to change the referenced person for each object. You can only delete the person if ALL of the references have been removed.

In addition, IconMail references to the deleted person cause the mail to be unreadable. This includes messages sent by the person, or cc’d to the person. If the person used IconMail extensively, it is better to make the person Inactive than to delete it.

When a person is deleted, any linkages to that person are dissolved. That means the person is automatically removed from any role or group that was included in the person’s definition. The person is removed from any signatures in all policies, and if they were the only user referenced in the signature, it is removed as a requirement.

For example, if you wanted to delete the person named jones, you would enter the following command:

delete person jones;