Minimize/Maximize
Idea Details
 Points:9
 Votes:9
 Rank:28
 Unique Views:13
 Total Views:444
 Comments:1
 Favorited:0
Linked Ideas :
This idea is hidden. Toggle Visibility
BODS Repository on Oracle
(D2245)
9
Points
submitted:
May 18 2011
Category: 
General/Other
Status: 
Submitted

Hello,

We see that using repositories on SQL Server is an easy game process. At connection time, you can specify the default database you want to use and voilà, you are connected to the repository. It allows a developer to connect to multiple repositories, using the same authentication user (windows).

Now, in Oracle, the designer does not allow to select the default schema for the connection, meaning the only way to connect to a repository is to connect using the owner of the objects of the repositories ... What is the impact on this ? Very big security issues where developers are getting too much rights.

So, this post requests to add Oracle default schema feature at connection level for the designer. This is only a simple text box with the default schema name to specify and the command to execute at oracle level : alter session set current_schema=xxxxxx

Thanks for all

Promotes

Demotes

Recorded Projections
Record Projection
Current Projection
Projection History
Recorded Outcomes
Record an Outcome