Is there an escape character I can use to have AMBA ignore special characters? I have thousands of old user IDs which (unfortunately) have a comma in them which also happens to be the parameter used to separate input values. There's no token assigned to these users so I can't rely on other available attributes to reference these particular user IDs.
I think I've tried every variation of quotes and slashes I can think of but AMBA continues to interpret the comma as the start of a new parameter.
Example:
action,SecurityDomain,DefLogin
DU,MyDomain,sampleuser,12345
In this case "sampleuser,12345" is the actual ID of the user but my logs show "sampleuser" as principal not found.
Hi Ted,
The security console would be helpful if the names were similar but they're widely different so aside from doing them one at a time it wouldn't be practical. It's a good suggestion though.
I did however find a way to delete them directly from the database by locating the correct field in the schema. If anyone runs into this issue in the future, follow the steps in 000034865 - Deleting expired SecurID software tokens in the RSA Authentication Manager 8.x Security Console fails to get to the database and run the following command:
delete from rsa_rep.ims_principal where loginuid='username,with,special,characters';
This will work assuming the username doesn't have an apostrophe character in it, but in my case that only applies to a single user I can remove by hand. The AMBA utility may be able to handle an apostrophe though so with a combination of these two methods it should make it much easier to bulk delete users.