Problem solve Get help with specific problems with your technologies, process and projects.

How many Oracle IDs/passwords should we have for one data warehouse?

How many Oracle IDs/passwords should we have for one data warehouse implementation? Find expert advice on determining the number of Oracle accounts that is appropriate for your organization.

To maintain a single data warehouse/mart implementation our development team needs to access 50 user ID/password/server combinations. The architecture is one where atomic-level detailed information from fuel cost and billing systems is brought into the DW dimensional models then aggregates dimensionally modeled are generated in the data mart. The account access information is too much for anyone to remember so it is out on the server in a text file for reference and our passwords are not secure/changed because synchronizing them and parameter files is a task and a half. Basically our DBAs have gone wild architecting the environment without project/ETL team input. What is an ETL/project team to do in such an environment? Is this the norm?
This was last published in August 2001

Dig Deeper on Oracle data warehousing

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.