IBM Power Ideas Portal
This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).
Shape the future of IBM!
We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:
Search existing ideas
Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,
Post your ideas
Post an idea.
Get feedback from the IBM team and other customers to refine your idea.
Follow the idea through the IBM Ideas process.
Specific links you will want to bookmark for future use
Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.
IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.
ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.
Due to processing by IBM, this request was reassigned to have the following updated attributes:
Brand - Servers and Systems Software
Product family - Programming Languages
Product - Developer for Power Systems
For recording keeping, the previous attributes were:
Brand - Rational
Product family - Design & development
Product - Developer for Power Systems
RFE 44743 is currently rejected and our customer is asking for reconsideration. To complement the information he performed the following cost analysis :
Today, each time a connection is created, DS asks to define the scope of Oracle objects visibility with 1 setting 'catalog' than can acccept either "all" (all objects are visible, wheter the user has rights or not on these objects) or "user" value (only objects owned by the user are visible).
At AG2R LA MONDIALE, no connection to databases is established through users owning objects. The connections are established through "front users" who do not own any object, and for which "grant role" has been applied.
The consequence of this is that, :
- 'all' choice is exposing all objects, including the one for which front users have no right, so too much information is provided here without any value, as it's not usable
- 'user' choice is not usable as front users do not own any object
So the current workaround, as DS does not propose to use the 'role' mechanisms Oracle provide in standard (which is design choice which every DBA consider as irrelevant as it's a common standard), consists in selectioning 'all' option and filter each schema (70 filters to be setup one by one).
The workload for this is estimated like this :
- adapt template worskpace to modify filters : 8 hours
- package and deploy workspace : 16 hours
- on each workstation, modify workspace : 2 hours, to be repeated on 15 stations
So a total workload of 56 hours for each change.
Yearly, 6 changes are performed, representing an additional cost of 336 hours, that can be evaluated to about $22K $/ year
Considering the significant cost related to this work around, AG2R LA MONDIALE, IBM reference for Rational, is asking for reconsideration of this RFE.
Thank you for submitting the RFE. We have determined that the RFEs should be assigned to the IBM Data Studio team. Unfortunately IBM Data Studio is not on the RFE Community although we recommend you contact tech support for IBM Data Studio to submit the RFE.
This RFE is consistent with our strategy and product roadmap and IBM is continuing to evaluate.