The attribute names like email, firstName, etc., typically come from the ProvisioiningPolicy defined for your JDBC source. for create operation use can use Create Profile.
If you’re still unsure, this video JDBC Connectors in ISC - Watch This Before Deploying walks through onboarding a JDBC source and setting up the schema—definitely worth a watch for clarity!
Getting rolename and roleid for Stored Procedure Grant Access
For your next use case with the stored procedure to grant access, I assume roleid is an entitlement type (like a role or group in your system), and rolename is its readable name. To fetch these in your code in a Provisioning Rule, you can extract them from the provisioning plan’s account requests.
- Access the Provisioning Plan: SailPoint passes the plan object, which contains all the provisioning details. You can loop through the AccountRequest objects to find entitlement-related data.
- Fetch Entitlements: Entitlements (like roleid) are typically requested as AttributeRequest objects within an AccountRequest. You can check for these and grab their values.
Sample code snippet based on the Before Provisioning Rule guide IdentityNow Rule Guide - Before Provisioning Rule