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. You must create a procedure named M7x_GET_PRIVACY_MESSAGE. During connection to the mart, the existence of the procedure is verified.

To add a stored procedure to activate a custom message at connection

  1. Connect to your database editor and copy the sample stored procedure supplied in the Samples\Stored Procedures folder. Make changes to 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