Populating a group using database sources

Before you begin

To use this option:
  • You must know where the stored procedures of interest are defined.
  • The sources must not be stored in encrypted format.
  • You must have access to the stored procedure sources on those databases.

About this task

Guardium will analyze the stored procedure source code, on one or more database servers. Select a group and then run the Auto Generated Calling Prox process to scan your stored procedures. This process will check the selected group to see if any of the objects in that group can be accessed or if any of the commands in that group can be executed. Any matches will be added to a new group. To populate a group using database sources:

Procedure

  1. Open the Group Builder by clicking Setup > Group Builder (Legacy). Use the filter to find the group you want to populate, or click Next and find the group from the list of all groups.
    Note: This option can only be used with commands or objects group types.
  2. With the group selected, click Auto Generated Calling Prox, and select the Using DB Sources option. This opens the Analyze Stored Procedures panel.
  3. Click Add Datasource and select a datasource from the Datasource Finder. The selected datasource will appear in the Datasources pane.
  4. Optional: Fill in the Query parameters. Some fields only apply to certain databases.
    • For Sybase, MS SQL Server, and Informix, enter a database name to restrict the operation to that database. If it is blank, all stored procedures in the master database will be analyzed.
    • For MySQL, Oracle or DB2 only, enter a schema name to restrict the operation to databases owned by that schema. For MySQL only, the Schema Owner is in the form user_name@host, where host can be a specific IP or it can be a % to specify all hosts. To get all hosts, enter the schema name followed by %.
    • For MySQL, Oracle or DB2 only, enter a stored procedure name in Object Name. Wildcard characters may be used. For example, if only interested in the procedures beginning with the letters ABC, enter ABC% in the Object Name box.
  5. In the Source Detail Configuration section, do one of the following:
    • Add members to an existing group by checking the Append check box, and then selecting a group from the Existing Group Name menu.
    • Add members to a new group by entering the new group name in New Group Name.
      Note: Do not include apostrophe characters in a group name.
  6. Select Flatten Namespace to create member names using wildcard characters, so that the group can be used for LIKE GROUP comparisons. For example, if sp_1, is discovered, the member %sp_1% will be added to the group, and in a LIKE GROUP comparison, the values sp_101, sp_102, sss_sp_103, etc. would all match.
  7. Click Analyze Database to begin populating the group. The operation may take an extended amount of time to complete.
Parent topic: Populating a group from stored procedures