ODS Database User Security Guidance

Previous TopicNext TopicContents

ODS User Security in P6 Reporting Database 3.2

For P6 Reporting Database 3.2, P6 EPPM users had to be given Enterprise Reports module access to become reporting users in the ODS database. When granted module access, a database user is created in the ODS instance for the user name.

The ODS database users can only view the data they have permissions to view in the P6 EPPM database. P6 EPPM user passwords are not used as the ODS database users passwords. The ODS database users that are created for these P6 EPPM users have randomly generated passwords. An administrator (or a user with privileges to change other users's passwords) can reset the database user password in order to connect directly as the ODS database user.

User Database Access

The database access that the user has is based on a new role called P6Reports. This role gives the database user permissions to create a session. The user can only access public synonyms. These synonyms enable the user to view their P6 Reporting Database data. Because the user does not know the password, the recommended method for configuring P6 EPPM with the ODS reporting database is an SSO\LDAP configuration.

Configuration Information

See the P6 Reporting Database for ODS Installation and Configuration Guide (or the P6 Analytics and Star Database Installation and Configuration Guide if you purchased P6 Analytics) for specific configuration information. See Pre-defined BI Publisher Reports in the P6 online help for information about pre-defined reports.



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

Last Published Friday, January 31, 2014