Applied Oracle Security: Developing Secure Database and Middleware Environments- P37:Computer security is a field of study that continues to undergo significant changes at an extremely fast pace. As a result of research combined with increases in computing capacity, computer security has reached what many consider to be “early adulthood.” From advances in encryption and encryption devices to identity management and enterprise auditing, the computer security field is as vast and complex as it is sophisticated and powerful | 334 Part II Oracle Database Vault proposals with rules stored for the sales managers who have the best expertise to respond to the proposal. Expression Filters use an Oracle operator EVALUATE in a SQL WHERE clause and again rely on function-based indexes for performance. Expression rules use a collection of distinct data attributes called attribute sets and Oracle object types. The PL SQL APIs for creating these attribute sets and mapping them to the tables where the rule expressions will be stored requires two steps First you must disable the Oracle Data Dictionary realm and then you must disable the application realm Sample DBV Application diego_dbvmgr@aos -- disable the Data Dictionary realm diego_dbvmgr@aos BEGIN realm_name Oracle Data Dictionary description Defines the realm for the Oracle Catalog schemas SYS SYSTEM SYSMAN MDSYS etc. Also controls the ability to grant system privileges and database administrator roles. enabled audit_options END PL SQL procedure successfully completed. diego_dbvmgr@aos -- disable the application realm diego_dbvmgr@aos BEGIN realm_name Sample DBV Application description Sample to demonstrate feature integration with DBV enabled audit_options END PL SQL procedure successfully completed. Now we can create our Expression Filter objects for the solicited proposal example app_object_owner@aos -- create an Oracle object type of rule attributes app_object_owner@aos CREATE OR REPLACE TYPE proposal_type AS OBJECT industry VARCHAR2 30 service VARCHAR2 30 price_limit NUMBER Type created. app_object_owner@aos -- create the Expression Filter attribute set app_object_owner@aos -- based on the object type app_object_owner@aos BEGIN Chapter 7 Applied Database Vault for Existing Applications 335 attr_set proposal_type from_type YES END PL SQL procedure successfully .
