To mask stored procedure outputs, Dynamic Data Masking dynamically creates tables within the Sybase ASE database based on the structure of the result set. You define the temporary database and schema as symbols in the security rule set. Dynamic Data Masking creates tables in the temporary database and schema. Dynamic Data Masking then populates the table with data in the temporary database. Dynamic Data Masking names the tables in the temporary database in the following way:

DDM_<Procedure Name>_<unique long number for call>_<result set sequence number>

For example, a table in the temporary database might have the following name:

DDM_Proc_Dept_Emp_1426236444222_0

The unique long number for call and the result set sequence number are automatically generated numbers.

For each result set that the procedure returns, Dynamic Data Masking creates a new table in the temporary database and populates the table with data. Dynamic Data Masking then forms a select query for the table in the temporary database and masks the query based on the security rules. Dynamic Data Masking creates a temporary stored procedure in the temporary database that uses the masked select query. The client receives the results of the temporary stored procedure call.