Data warehouse is a set of integrated databases deliberated to sustain decision-making and problem solving, embracing highly abridged data. Data warehouse happens to be progressively acknowledged subject for contemporary researchers with respect to contemporary inclination of industry and organizational purview. Data warehouse is one of the imperative contrivances for decision support system. Data warehouse is a repository which contains all the organizations data in entire capacity. Concentration of hacking has been intensifying diurnally; hence the incorporation of security mechanism has become a decisive concern for any organization in shielding the sensitive data.