CA ERwin Data Modeler Workgroup Edition › Connect to the Mart › Custom Security Message at Connection › Add the Stored Procedure to Activate a Custom Message at Connection

Add the Stored Procedure to Activate a Custom Message at Connection

As the administrator, you can add a custom message to the Connection dialog based on a stored procedure. If the stored procedure is supplied, then the feature is active, otherwise the feature is dormant. Create a procedure named M7x_GET_PRIVACY_MESSAGE. During connection to the mart, the existence of the procedure is verified.

Follow these steps:

1. Connect to your database editor and copy the sample stored procedure supplied in the Samples\Stored Procedures folder. Change the file and save as a script file.
2. Connect to the mart as the schema owner, and compile the script as M7x_GET_PRIVACY_MESSAGE.

   The procedure is created.

More information:

Custom Security Message at Connection