Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking
  3. Rules
  4. Connection Rules
  5. Security Rules
  6. Security Rule Set Simulator
  7. Masking Functions
  8. Stored Procedure Result Set Masking
  9. Integration with Informatica Products
  10. Appendix A: XML Functions Reference
  11. Appendix B: Glossary

Lookup into Symbol Action

Lookup into Symbol Action

The Lookup into Symbol action calls a PL/SQL function or Java function with or without input parameters and returns a value for the defined symbol name. You can use the defined symbol name in the next rules for processing.
Use the Lookup into Symbol action when user access to data is based on other data elements in the database or an external system.
For example, a database might map a user name to a team name, a team name to a subject area, and a subject area to table names. If a user has access to the table name, you want to allow the query. Otherwise, you want to block the query. You can use the Lookup into Symbol action to implement a PL/SQL function to determine whether the user has access to the table name and return the result into a defined symbol name.
To define a global symbol, select the
Keep Per Session
check box. A global symbol lasts throughout the client session and exists until the client disconnects from the database.
If you do not want the symbol to be a global symbol, clear the
Keep Per Session
check box. If you clear the
Keep Per Session
check box, the symbol exists only during the SQL request.
The Lookup into Symbol action supports the following lookup types:
Java
The Java lookup type runs a Java class that returns the value for the defined symbol name.
PL/SQL Function
The PL/SQL lookup type runs a PL/SQL function that returns the value for the defined symbol name.