Empty User records in the User table

[osolaru063]

How do i prevent the creation of empty user records that don't have user IDs.

I am seeing empty records being created in the sys_user table. Is there a way to create a script that will block the creation of empty records on the sys_user table?   

Also I have an existing Transform script that flags inactive accounts in AD. My 2nd question is, can I modify the existing transform script or create another script for blocking the creation of empty records.

[Fabian Kunzke]

Hey,

For this create an onBefore business rule, which is triggered on Insert. Add the trigger condition to check if the user id is empty.

Then in the tab "Actions" there is a flag which is called "abort action". Setting this flag will prevent any further database interactions for this record and abort the insert.

Regards

Fabian

NOTE: make sure to document this well. There may be a case where creating user records without an id has some merit (though to be honest i cannot come up with one).

[Prince Arora]

@osolaru063 

Please write a before insert Business Rule like below:

If my answer solved your issue, please mark my answer as ✅Correct & 👍Helpful based on the Impact.

[Fabian Kunzke]

Hello,

short feedback; As i written in my answer, there is actually no code needed. Rather under "Actions" there is a flag which enables "abort action" without code.

Regards

Fabian

ps.: Love the inclusino of screenshots!