Add or Modify a Database's Data Source Properties

Use this topic to understand and specify a database's data source properties.

These are the data source properties that you can assign to a database:

  • Virtual Private Database - Available for all data sources. Select to identify the database source as a virtual private database (VPD). When a VPD is used, returned data results are contingent on the user's authorization credentials. Therefore, it's important to identify these sources. These data results affect the validity of the query result set that's used with caching. See About Row-Level Security.

    If you select this option, then you also should select the Security Sensitive option in the session variable's Variables tab.

  • Siebel CRM Database - Available for relational data sources. Select to indicate that the definition of physical tables and columns for Siebel CRM tables was derived from the Siebel metadata dictionary.

  • Allow direct database requests by default - Available for relational and Essbase data sources. If this property is configured incorrectly, it can expose sensitive data to an unintended audience.

    Select to allow all users to run physical queries. The Oracle Analytics query engine sends unprocessed, user-entered, physical SQL directly to an underlying database. The returned results set can be rendered in the Oracle Analytics query engine and then charted, rendered, and treated as an Oracle Analytics request.

    If you want most but not all users to be able to run physical queries, select this option and use the Query Limits tab to limit queries for specific application roles.

  • Allow populate queries by default - Available for relational data sources. Select to allow everyone to run POPULATE SQL. If you want most, but not all, users to be able to run POPULATE SQL, select this option and then limit queries for specific users or groups.

  1. On your home page, click Navigator Navigator icon and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Physical Layer Physical layer icon and locate and double-click a database.
  4. In the database's tab, click Advanced.
  5. Go to the Data Source Properties section of the Features table and specify the database's data source properties.
  6. Click Save.