Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
what user name and password is the Analasis subject areas using.
Sorry for the dumb question, but it appears I cannot get a clear answer on this particular question. What user name and password will be used for the the analysis that I write? It appears that the username and password will default to whatever the connection pool that I used to build the RPD. In a multiuser enviroment I wouldn't want to merge those developers user names and passwords into the the existing RPD. Can I set a global username and password?
Thanks
M.
Answers
-
If you don't setup your connection pool to not use a shared login it's not default to anything, it's way it's supposed to work !
The username / password are stored in the connection pool.
Not clear what you are asking with "developers user names and global username".
Do you mean that all your RPD developers use their own person account in the RPD?
Why don't you give them the technical account that your final RPD is supposed to use? You can also use variables to define these parameters so that you manage centrally in a single (or few) variables these details.
When you merge together multiple RPD you are not supposed to override your connection pool with the one coming from the developer or you must add a step in your process where somebody set the correct username and password there.
0 -
First of all it's a VERY VERY bad idea for developers to use their credentials when configuring the RPD. Never ever do that as it may accidentally give access for users to sensitive information they should not be able to see. Worst case you could implicitly give DBA rights access through the RPD and good luck if somone then finds the direct DB request functionality. Also if a developer leaves his credentials may be deprecated and hence accesses lost. Same thing for password renewal rules which are in place for must human users vs technical/ system user accounts.
Connection pools should contain credentials of technical users with non-expiring passwords and clearly defined rights or : USER / : PASSWORD (without the spaces - : P otherwise comes out as ).
0 -
Gianni,Christian
Thanks for response. I'm completely new to OBIEE and I'm still trying to understand how things work. I apologize I was not very clear in asking my question. I don't want to have all the developers use their user name and passwords while working on their projects. My question to you guys is, if I have multiple developers working on projects which will than be submitted to me to merge to one single RPD, how do I make a variable for the connection pool? That's really the part I'm not following. Thus far it appears that when you are creating a project using the BI administration tools. you have to connect to the DB with your own user name and password. Again, I'm trying to understand how things work, forgive my ignorance.
0 -
mlov83 wrote:Gianni,ChristianThanks for response. I'm completely new to OBIEE and I'm still trying to understand how things work. I apologize I was not very clear in asking my question.
No worries you very clear enough, that's not the issue.
mlov83 wrote: I don't want to have all the developers use their user name and passwords while working on their projects.
That's what I meant. You never ever should use a personal login to connect to any data source but a technical (non-human) user for the reasosn I mentioned above:
- you can never be sure that the access rights are correct (both too permissive and too restrictive)
- You can never assume the password won't expire
- you can never be sure that the account doesn't get deleted when the person leaves
- you can never know whether the account is restricted in terms of resources
- ....
mlov83 wrote:My question to you guys is, if I have multiple developers working on projects which will than be submitted to me to merge to one single RPD, how do I make a variable for the connection pool? That's really the part I'm not following. Thus far it appears that when you are creating a project using the BI administration tools. you have to connect to the DB with your own user name and password. Again, I'm trying to understand how things work, forgive my ignorance.
Not ignorance, just learning. It's a normal process.
So if you look at the SampleApp RPD (screenshots in a second when I switch machines) you can see for example VALUEOF(DW_USERNAME) being ussed which points to a static RPD variable:
Other connection pools use technical (non-human) accounts:
And lastly I modified one to show that use of :USER which means that the OBI user credentials get handed back to the database:
0 -
For the last screenshot of Christian uncheck "Shared logon"
0 -
Yes I just wanted to show where :USER goes, you config-n@zi :-P
0 -
Thanks Christian,
Now It makes sense. I really appreciate your time in answering these noob questions.
0 -
You're willing to learn and you show proper netiquette. No problem whatsoever answering your questions. We just have an issue with "DO MY JOB NOW URGNET !!1!!111!1" posts
0
