User-Level Security and User Name Restrictions

Previous TopicNext TopicContents

For the ODS to properly implement P6 EPPM user-level security, the ODS will create a database-level user if you give a user the Enterprise Reports module access in P6 (see the P6 Help for more information).

You will have two options for creating security for the ODS user.

Option 1: Use the Database Security Model

For this method, you create the database users, and their views are based on what they have security access to view. The P6 EPPM user name must:

The ODS implements security that applies to the Oracle database, which is why you must use these specifications for the user name.

Database views are created for the ODS tables. The ODS database then creates public synonyms and gives users access to these synonyms. When the ODS database user accesses the tables, row, and fields through these synonyms, a filter is applied that gives users access to data based on their P6 EPPM security attributes.

If the user is an application user and has Enterprise Reports module access in the P6 EPPM database, the Oracle instance of the ODS database will create a database login for the user. The user can log into the P6 EPPM application with the application user password. The user cannot log into the ODS database directly (for example, using SQL Plus) because the ODS user has been created with a randomly generated password. Therefore, the application user must have the ODS database user's password reset by a system administrator.

If you use this option, you will need to use Database Authentication and the JDBC connection with the Proxy option selected when using BI Publisher. If you use this option, your user names would compare as follows:

Method 2: Use the Security Package (SECPAC)

Your second option is to use SECPAC. SECPAC is an internal database security package for Oracle that sets session variables for security. If you use SECPAC, you will need to consider the following when using BI Publisher.

Related Topics

Overview of BI Publisher

Installing Oracle BI Publisher

About Configuring P6 Database Connection Settings for BI Publisher

Configuring the JDBC Connection

Copying the P6REPORTS Folder for BI Publisher 11g

Configuring BI Publisher Security

BI Publisher Database Authentication Setup

Setting Up LDAP with BI Publisher



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014