Which IIQ version are you inquiring about? Version 8.4 Share all details related to your problem, including any error messages you may have received. Hi All, I have a requirement to generate a sequence number (6 digit number) and set it as username on identity cube when creating a new identity cub…

@jjain Welcome back to community You can simply create a database sequence for this within your database and use the nextval of the sequence every time you create or set the username This will be simple approach with no much customisations

Other option you can follow is just have a check for max(username) on existing contractor identities filter condition and increment by 1 , but this would be a issue if at all there is a concurrent processing happens , you can go with approach if concurrency is not a case

[image] J Jain: I have a requirement to generate a sequence number (6 digit number) and set it as username on identity cube when creating a new identity cube for contractors. I was looking for suggestions which requires minimum customisation. Hi @jjain : Apart from the solution provided by @…

You could also use a Custom Object to hold the last used value. that would be easier. Best!

I did think about Custom object but Custom object are usually used for storing static information.

Why don’t you create a db sequence ?

When the DB column is using sequence, how do you return/get the nextval to display in the ‘create account policy’ for a jdbc connector? Are you already connected to the DB at this point, or do you have to connect, select and then return the next seq value?

We have done this many times all leveraging the database. Either a sequence or generate a stored procedure to pick a random value from a seeded table. You can leverage the locking capabilities which is super helpful too.

Custom objects are for all kinds of information, not just static info. At one client I shoved all of the identity’s roles and entitlements into a Custom object at the beginning of the termination process, just in case it needed to be reversed. The main thing is to be thread safe, to be sure to loc…

Sequence Generator for userid

IdentityIQ (IIQ) IIQ Discussion and Questions

jjain (J Jain) May 15, 2024, 4:16am 3

Thanks @iamksatish for the reply.

I was wondering if there were any other options besides database sequence as creating a DB sequence would need DBA help.

Topic		Replies	Views
Username Generator with uniquecounter /variable with a custom starting value ISC Discussion and Questions identity-security-cloud	3	67	May 25, 2026
How to create a user login user a sequence number available for all users? ISC Discussion and Questions transforms , rules	12	982	August 19, 2023
Save last generated User ID ISC Discussion and Questions identity-security-cloud	2	197	April 12, 2024
Query all Identities for Username Generation? ISC Discussion and Questions	5	2144	July 19, 2023
Generate unique samaccount based on user type ISC Discussion and Questions identity-security-cloud , provisioning	16	174	May 5, 2026

Sequence Generator for userid

Related topics