If you are using a stored procedure for provisioning the user database, specify its location on this screen.

Stored Procedure Location
Note:

This screen appears only when a Microsoft SQL Server datastore is chosen on the User Repository screen and the Stored Procedure option is selected on the SQL Method screen.

Important:

The database account used by PingFederate must have access to the schema in which the stored procedure is located and to execute permission for the procedure.

  • Select the database schema and the stored procedure.
    Field Description
    Schema Select the table structure that contains stored procedure within the database.
    Stored Procedure Select the stored procedure needed to provision the user database.
    Procedure parameters to fulfill For the selected procedure, all parameters and their data types are displayed.

    If the list of parameters is not or might not be current (due to any recent procedure revisions), click Refresh.

    You map attribute values from the SSO token to the parameters on the Attribute Fulfillment screen.
    Tip:

    Click the link near the lower-left corner of the screen to see a list of available attributes from the SSO token.