Q

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 first published in August 2001

Dig deeper on Oracle data warehousing

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close