1 - Delete the Sample Projects
First, for both cloud and on-premise customers, you need to delete all three sample projects using the Administration > View/Edit Projects page:
- Library Information System
- Sample Application One
- Sample Application Two
2 - Physically Delete the Sample Users
The next step will depend on whether you are cloud hosted or on-premise. For on-premise customers, you need to run these SQL commands to delete the sample users:
DELETE FROM TST_USER_PROFILE
WHERE USER_ID >= 2 AND USER_ID <= 13
GO
DELETE FROM TST_USER_COLLECTION_ENTRY
WHERE USER_ID >= 2 AND USER_ID <= 13
GO
DELETE FROM TST_USER_CONTACT
WHERE CREATOR_USER_ID >= 2 AND CREATOR_USER_ID <= 13
GO
DELETE FROM TST_USER_CONTACT
WHERE CONTACT_USER_ID >= 2 AND CONTACT_USER_ID <= 13
GO
DELETE FROM TST_DATA_SYNC_USER_MAPPING
WHERE USER_ID >= 2 AND USER_ID <= 13
GO
DELETE FROM TST_PROJECT_GROUP_USER
WHERE USER_ID >= 2 AND USER_ID <= 13
GO
DELETE FROM TST_USER
WHERE USER_ID >= 2 AND USER_ID <= 13
GO
For cloud customers, you need to just send in a support ticket to us and provide the URL of your Spira instance.