Chuck Kelley's Answer: It will totally depend on your data. If your data requires high amount of security (e. g., social security numbers, salary, etc.), then you will need a security policy that strictly enforces access. If your data is manufacturing and/or quality, then maybe the security policy can be full access. Is there is any standard methodology for the use of ETL tools or does it depend on the tool itself? We are at the process of buying a tool.Les Barbusinski's Answer: I'm unaware of any universal DW/BI security policy. Every company deals with its security issues in its own way. However, some security policy areas relevant to data warehouses and BI applications include the following:

Hope this helps.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access